Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column
 Login/Join
 
Gold member
posted
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
 
Posts: 72 | Registered: July 10, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
I found out what the issue is.

Needed: setStackedDataValueSum(false);


WebFOCUS 8204
 
Posts: 72 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.