Hi,
I am working on a project using line graph.
So, i want to show the minimum value of the data in the lines.
Is it possible?
Also is it possible to change it's font size and color?

Thanks in advance.

This message has been edited. Last edited by: <Rita>,

Rita

First of all we would like you to upgrade your signature with info about version and things like that.

To answer your question, yes it can....
Not much of a help I think..

Can you post a bit of the script that shows the data you want.
If possible do that with data from the CAR database.

Do you have the pdf documentation on graphs?
(wf713graph.pdf)
It tells you everything you want to know about graphs.

Do you use the GUI?

Hi Frank
Thanks for your reply
I have updated my signature
No, i have no idea about pdf documentation
Yes, i am using GUI.
I am very new to WebFocus.
Below is the code what i am using do get the graph.I want to show the last value on the lines

GRAPH FILE RTN_PCT
SUM PRET AS ''
ACROSS WEEK AS 'Week'
BY RATING1 AS 'Rating'
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
-*SET APPLET SIZING=ON
ON GRAPH SET VAXIS 518
ON GRAPH SET HAXIS 985
ON GRAPH SET GRMERGE ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getLegendArea(),new Color(204,51,51));
setMarkerDisplay(true);
setUseSeriesShapes(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setFillMissingData(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1AxisLineDisplay(true);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTextJustHoriz(getLegendText(),0);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),11);
setTextRotation(getLegendText(),0);
setTextWrap(getLegendText(),false);
setTextJustHoriz(getY1Title(),1);
setFontSizeAbsolute(getY1Title(),true);
setFontSize(getY1Title(),12);
setFontStyle(getY1Title(),0);
setTextRotation(getY1Title(),1);
setTextWrap(getY1Title(),false);
setTextJustHoriz(getY1Label(),0);
setFontSizeAbsolute(getY1Label(),true);
setFontSize(getY1Label(),12);
setTextRotation(getY1Label(),0);
setTextWrap(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setTextJustHoriz(getO1Title(),1);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),12);
setFontStyle(getO1Title(),0);
setTextRotation(getO1Title(),0);
setTextWrap(getO1Title(),false);
setTextJustHoriz(getO1Label(),0);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),12);
setTextRotation(getO1Label(),2);
setTextWrap(getO1Label(),false);
setPlaceResize(getLegendText(),0);
setPlaceRotate(getLegendText(),0);
setPlaceAlign(getLegendText(),0);
setPlaceWordWrap(getLegendText(),0);
setPlaceResize(getY1Title(),0);
setPlaceRotate(getY1Title(),0);
setPlaceAlign(getY1Title(),0);
setPlaceWordWrap(getY1Title(),0);
setPlaceResize(getY1Label(),0);
setPlaceRotate(getY1Label(),0);
setPlaceAlign(getY1Label(),0);
setPlaceWordWrap(getY1Label(),0);
setPlaceResize(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setPlaceAlign(getO1Title(),0);
setPlaceWordWrap(getO1Title(),0);
setPlaceResize(getO1Label(),0);
setPlaceRotate(getO1Label(),0);
setPlaceAlign(getO1Label(),0);
setPlaceWordWrap(getO1Label(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR=RGB(144 144 144),
BACKCOLOR=RGB(204 51 51),
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
ENDSTYLE
END

Rita,

Firstly, I would recommend obtaining the PDF document that Frank suggests. It will provide you with many a resolution and a better understanding of how the graph engine works. You can download it from the IB support site once you have logged in.

The setting you require is -
setDataTextDisplay(true);

But this will show data text on all points and not just the last one. I am not sure if you can restrict the display as you wish.

T

Tony,
I know by using setDataTextDisplay(true);
i can get all the points but as per the requirement i need only the last value.
Could you please send me the site where i can download wf713graph.pdf

Thanks
Rita

Rita

What I would do in this case is add an extra calculated field in the request that shows the last value and display that in an annotation via an amper value.

Since I'm not sure what you mean by the "last" it's not so easy to create the script for you.

The script on how to do that can be found in the documentation, but is to much to copy here.

An other way is use the function

setDataTextDisplay(true);
setSeriesDataTextDisplay(getSeries(1), false);

And put the "last" value in an extra field in the graph.
This is not so easy, because you have to play with things like "MISSING IS ON" so you get a little extra line for that "last" value.

Frank,

Last value means the lowest data value.
And this value is not fixed,every week it will keep changing.I am running the report through Report Caster, so every week it has to display only the lowest data value on the graph.
Is it possible to display this data value?
Thanks.........

Rita

yes it is

TABLE FILE XXX
SUM MIN.PRET
ON TABLE HOLD AS HOLDMIN FORMAT ALPHA
END
RUN
-READ HOLDMIN &MINIMUM
-TYPE &MINIMUM

Now you can put the amper value in the graph as an annotation, or in the legend or in the graph title.

(I'm not sure if you have a minimum per rating1 and if so how many rating1 lines you have)

Frank,

Thanks for the information.
Yes, I have a minimum per rating1 and i have 5 rating1 lines in a single graph.

Rita

Than the better way to do this is adding these minimum values to the graph request as extra points.
So on every line you will get one field that holds the minimum.

I think I can do it, but you have to wait till next week, since now it's my holiday and I do not have the software at home.
Can you send the data in a focus hold file with the master to my mail address: frank.terlien@gmail.com

I played a bit with the data and got this result

SET ASNAMES = ON
SET GMISSVAL = 0
SET GMISSING = ON
TABLE FILE FPDATA
SUM
     MIN.VALUE AS 'MINIMUM'
BY RANKNR
SUM
     VALUE
BY RANKNR
BY WEEK
ON TABLE NOTOTAL
ON TABLE HOLD
END
TABLE FILE HOLD
PRINT
     RANKNR
     WEEK
     MINIMUM
     VALUE
COMPUTE  R/I4 MISSING ON=MISSING; NOPRINT
     COMPUTE NEXTMIN/I3 MISSING ON = IF MINIMUM EQ VALUE THEN MINIMUM ELSE R;
ON TABLE HOLD AS HOLD1
END
GRAPH FILE HOLD1
SUM VALUE NEXTMIN AS ''
ACROSS WEEK AS ''
BY RANKNR
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID OFF
ON GRAPH SET VAXIS 500
ON GRAPH SET HAXIS 800
ON GRAPH SET GRMERGE ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setDataTextDisplay(true);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), true);
setDisplay(getDataText(2), false);
setDisplay(getDataText(3), true);
setDisplay(getDataText(4), false);
setDisplay(getDataText(5), true);
setDisplay(getDataText(6), false);
setDisplay(getDataText(7), true);
setDisplay(getDataText(8), false);
setDisplay(getDataText(9), true);
setLegendDisplay(true);
setSeriesLabel(8, "Perfect");
setSeriesLabel(1, "");
setSeriesLabel(6, "High");
setSeriesLabel(3, "");
setSeriesLabel(4, "Average");
setSeriesLabel(5, "");
setSeriesLabel(2, "Loser");
setSeriesLabel(7, "");
setSeriesLabel(0, "Very bad");
setSeriesLabel(9, "");
setMarkerDisplay(false);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setFillMissingData(0);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,2);
setAxisAssignment(1,0);
setSeriesType(1,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTextJustHoriz(getLegendText(),1);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),9);
setFillColor(getLegendText(),new Color(0,0,128));
setTextRotation(getLegendText(),0);
setTextWrap(getLegendText(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getLegendText(),0);
setPlaceRotate(getLegendText(),0);
setPlaceAlign(getLegendText(),0);
setPlaceWordWrap(getLegendText(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N3 EQ 0,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     COLOR='TEAL',
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     COLOR='YELLOW',
     MACRO=COND0001,
$
ENDSTYLE
END

Before I created a smal file with these data.

Let me know is this is what you wanted.

Hi Rita,

You can view and/or download the WebFOCUS Graphics Version 7.1.3 and Higher manual (DN4500708.0206) from the i-Base: The Technical Documentation Library.

If you have an InfoResponse ID, log on to the Tech Support Web site and then access i-Base. By logging in first, you can download the PDF file and/or view the HTMLHelp version.

You can access i-Base via the following Web sites:

• http://techsupport.informationbuilders.com
  (From the top navigation bar, click Publications. Then select i-Base: Tech Doc Library.)
  
• www.informationbuilders.com
  (From the top navigation bar, click Services & Support. Then select Documentation.)
  
• www.iwaysoftware.com
  (From the top navigation bar, click Services & Support. Then select Bookstore.)
  

Hope this helps.

Regards,
Jennifer

Frank,

Thanks a lot for the information.
It's working.

Rita

The markers is a special problem, I was looking in the legens to see if I can display a selected field. I did not find it. So my suggestion would be to change the color of the marker and make the text empty. The color should be the same as the bg color, in your case RED, so it comes out in the graph as red and in the legend it will disappear against the bg.

Maybe someone knows if it is possible to selective display legends.

Will this be helpfull?

Rita

I found this code in the documentation

setMarkerSize(0,60);
setMarkerShape(0,6);
setMarkerSize(1,60);
setMarkerShape(1,5);
setMarkerSize(2,60);
setMarkerShape(2,4);
setMarkerSize(3,60);
setMarkerShape(3,3);
setMarkerSize(4,60);
setMarkerShape(4,2);
setMarkerSize(5,60);
setMarkerShape(5,1);

So you can play with the individual markers , size, color and form.

I did not test it, but try to change the size of some of the markers to zero.
See if that helps.

Did you manage to download the pdf file?

Let me please know if the result is what you needed.

Frank,

I tried the code sent by you, but it's not working.
Yes, I am able to download the pdf file.This is very helpful, i can get everything about the graph.Thanks a lot for sharing the information.
I tried to search in this file but I am not getting which I need.
Still I am not able to solve my issue.

Rita

I played a bit with these settings

setSeriesLabel(8, "Perfect");
setSeriesLabel(1, "");
setSeriesBorderColor(1,new Color(255,255,255));
setSeriesFillColor(1,new Color(255,255,255));
setSeriesLabel(6, "High");
setSeriesLabel(3, "");
setSeriesBorderColor(3,new Color(255,255,255));
setSeriesFillColor(3,new Color(255,255,255));
setSeriesLabel(4, "Average");
setSeriesLabel(5, "");
setSeriesBorderColor(5,new Color(255,255,255));
setSeriesFillColor(5,new Color(255,255,255));
setSeriesLabel(2, "Loser");
setSeriesLabel(7, "");
setSeriesBorderColor(7,new Color(255,255,255));
setSeriesFillColor(7,new Color(255,255,255));
setSeriesLabel(0, "Very bad");
setSeriesLabel(9, "");
setSeriesBorderColor(9,new Color(255,255,255));
setSeriesFillColor(9,new Color(255,255,255));
setLegendDisplay(true);
setMarkerDisplay(false);
setConnectLineMarkers(true);
setTransparentMarkers(true);
setTransparentMarkerSize(100);

Give this a try, what you should see is the control over the different lines and markers.
by changing the marker size (last line) or stting transparancy to false the display will change.

The color of the individual lines can be changed by these settings, I now made them white and since my bg is white too, you do not see them, if your bg is red, make the color red too.

Since these settings are ment for bars, they do not influence the line color but only the legend (This might be a bug...)

Let me know if this works.

Frank,

Thanks a lot.
The code is working fine.But whenever I am running it through Report caster I am getting the markers again.I am running it in FTP format.
But while running it directly the markers are not coming.And in the legend side also the text is not coming completely.
Could you please tell why it is coming like this while running through Report Caster?

Rita

Rita

This is strange
I tried this too, created a PDF that should hold the graph, got a problem but that was solved with

SET GRAPHSERVURL=http://localhost/ibi_apps/IBIGraphServlet

Now when I schedule the proces the report with the graph looks the same as when I run it from the MRE.

If you keep having a problem, you can send a mail to the techsupport from IBI.

The default in WF/MRE direct requests is that the reporting sever calls pack to the web tier to build a grapfh. It uses GRAPHSERVURL to tell the server to pass the call back adress. In caster, the default is to use a java layer packaged with the server (JSCOM3). If GRAPHSRVURL solves the problem then there are a few reasons:
1. The version of the server is different then on web tier.
2. The graphics card on the server machine is very different then on the web tier. This rarely makes much of a perceptable difference, but if you machine compare the output, there are differences.
3. There is a bug in graphics under jscom3.

Is there a simple case (uses a standard db) that exhibits the difference? (Also need server/web tier levels).

I am able to solve my issue.Previously I was running the fex in Report Caster which contains the code for both report and graph.Now I have created two fex files, one for report and one for graph.I have holded the data in one fex and scheduled it through Report Caster and linked the other fex which contains the graph to launch page.So, whenever I will click the drop downs in launch page it will run the graph fex file and give the output.
So, the output is coming properly now.

Thanks a lot Frank.


Rita

Rita

That's nice to hear it is working.

You can however create a compound report with both the table and the graph and schedule that by report caster, but that is a challange and if the solution you have build now is working fine I would not change it anymore.