Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Need information on line graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Need information on line graph
 Login/Join
 
<Rita>
posted
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>,
 
Report This Post
Virtuoso
posted Hide Post
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?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Rita>
posted
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
 
Report This Post
Expert
posted Hide Post
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



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
<Rita>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Rita>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Rita>
posted
Frank,

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

Rita
 
Report This Post
Virtuoso
posted Hide Post
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




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
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.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<DocServices>
posted
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:


Hope this helps.

Regards,
Jennifer
 
Report This Post
<Rita>
posted
Frank,

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

Rita
 
Report This Post
Virtuoso
posted Hide Post
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?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
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

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Rita>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Rita>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
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).


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Report This Post
<Rita>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Need information on line graph

Copyright © 1996-2020 Information Builders