Focal Point
[CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1697050296

November 26, 2019, 04:59 PM
Brandon Andrathy
[CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column
Hello,

I am currently trying to make a trend line display in relation to the sum of a stacked graph and not in relation to the highest value in the stacked graph. In the CAR example below, the trend line in column "4" should be in line with the sum between RETAIL_COST and DEALER_COST. Does anyone have an idea how to do this? Thanks in advance!!

 GRAPH FILE CAR
SUM
	DEALER_COST
	RETAIL_COST
	SALES
BY SEATS AS ' '
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET VZERO OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=HEADING, JUSTIFY=CENTER, FONT='ARIAL', STYLE=BOLD, SIZE=11, COLOR=RGB(75 75 75), $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setFillColor(getDataText(0), new Color(255,255,255));
setSelectionEnableMove(false);
setSeriesType(2,2);
setLegendPosition(1);
setDisplay(getY1Title(),true);
setFillColor(getSeries(0),new Color(0,77,113));
setFillColor(getSeries(1),new Color(124,201,126));
setFillColor(getSeries(2),new Color(6,194,255));
setDataTextDisplay(true);
-*setTextFormatPreset(getDataText(),6);
setDataTextPosition(4);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1Label(),false);
setDisplay(getY1MajorTick(),false);
setY2LabelDisplay(true);
setY2AxisSide(0);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
*GRAPH_JS_FINAL
"xaxis": {
    "title": {
        "visible": false
    }
}
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH
-RUN
 

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
November 27, 2019, 11:10 AM
Brandon Andrathy
I found out what the issue is.

Needed: setStackedDataValueSum(false);


WebFOCUS 8204