A hopefully simple question that I could not find an answer for in FP or the docs.
I have a VBAR graph with 2 series. Series 0 should be bars, series 1 a line. All shows OK EXCEPT for the series 1, which instead of showing just the line shows bars as well.
Code:
SET GRMERGE=ON
GRAPH FILE TESTFILE
SUM RUNTIME AS '' TOT.RUNTIME AS ''
ACROSS SCHEDDATE AS ''
BY GROUP1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 0
ON GRAPH SET HAXIS 1200
ON GRAPH SET VAXIS 640
ON GRAPH SET GRAPHSTYLE *
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setSeriesType(1,2);
setPlace(true);
ENDSTYLE
...
Any ideas on how to keep the line for series 1 while removing its bars?This message has been edited. Last edited by: Microfich,
You have WebFOCUS 762. That is already equipped with the Advanced Graph Assistant. You can do this very easily with that tool. Per series you can indicate what type of graph it should be, it works! Check out this tool, I have learned a lot about graphing using it.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 04, 2010, 03:21 PM
Microfich
quote:
ply
Unfortunately, AGA is not properly installed. Admin is on it but I have to code graphs by hand.
Shouldn't setSeriesType(1,2) take care of it? What am I missing?
Ok, bad enough that you don't have AGA. So I have create a small example where I plot the dcost and rcost from the car file in one graph. One bar, one line. The code is:
GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.BODY.BODYTYPE
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPlace(true);
setSeriesType(getSeries(0),2);
ENDSTYLE
END
Guess you right. If I try to do that with the car file (by country across car) I end up with just as many series as there are car brands. You just can't create a line for that. Is there some possibility that you can do it without across?
Then you'll actually get two distinct series along the same axis and you'd be able to specify their types (using the advanced graph variant of course) as mentioned by others.
I'm still fairly new to WebFOCUS, but in my experience it's often easier to graph a result if the different graph components each have their own column than to try to combine multiple graphs into a multigraph.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :