A while back I found this great tool tip graph script code and adapted it to a few charts. Now I have a stacked bar chart and I can't figure out how to get the column total instead of the grand total.

In the code below, within the function, you see the variable "total". This is used to calculate the percentage "d" and then used in the tooltip. The problem is, I need the total to be the total of the month column data. But it appears to be the total for all of the columns of data.

You can see in the screen shot that the tool tip show 14.2% as the percentage but clearly the bar is showing closer to 50%.

Anybody accomplished this?

*GRAPH_JS
"introAnimation": {
 "enabled": false,
 "duration": 1400
},
*END
*GRAPH_JS
"riserBevel": "none",
"introAnimation": {
 "enabled": false,
 "duration": 1400
},
htmlToolTip: {
	enabled: true,
-*    snap: true,
    style: {
		border: '#99FFCC',
		background: '#99FFCC',
	},
},
series: [
{ "series": 'reset',
	"tooltip": function(d,s,g){
	    var valueArr = this.data[0],total=0;
		    for (var i=0 ;i<valueArr.length;i++){total+=valueArr[i];}
                           var sum= d / total * 100 ;
debugger;
return this.getSeries(s).label + " For " +this.getGroupLabel(g)+': '+ this.formatNumber(d, '#,#')+ '<br>'+' Percent of Total ' +this.getSeries(s).label + ': '+sum.toFixed(1)+ "%";
 }
  },
]
*END  

This message has been edited. Last edited by: FP Mod Chuck,

Do not use the default IBI tooltip, build your own.

TABLE FILE CAR
SUM COMPUTE VAR     /P6C   =  RETAIL_COST - DEALER_COST;
    COMPUTE VAR_PCT /P6.2C = (RETAIL_COST - DEALER_COST) / DEALER_COST * 100;
BY COUNTRY
ON TABLE HOLD AS TMP
END
-RUN

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET HTMLENCODE=ON
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='240.0';
-DEFAULTH &WF_STYLE_WIDTH='460.0';
-DEFAULTH &WF_TITLE = 'WebFOCUS Report';

GRAPH FILE TMP
SUM VAR  AS 'Variance'
    COMPUTE DIMX      /A30V = COUNTRY;
    COMPUTE VARX      /A30V = FPRINT(VAR, 'P6C', 'A10V') || ' $';
    COMPUTE VAR_PCTX  /A20V = LJUST(10, FPRINT(VAR_PCT, 'P6.2C', 'A12V'), 'A10V') || ' %';
BY COUNTRY AS ''

ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='TIMES NEW ROMAN', SIZE=10, COLOR=RGB(8 97 74), STYLE=NORMAL, $
TYPE=DATA, COLUMN=COUNTRY,  BUCKET=x-axis, $
TYPE=DATA, COLUMN=VAR,      BUCKET=y-axis,  $
TYPE=DATA, COLUMN=DIMX,     BUCKET=tooltip, $
TYPE=DATA, COLUMN=VARX,     BUCKET=tooltip, $
TYPE=DATA, COLUMN=VAR_PCTX, BUCKET=tooltip, $
*GRAPH_JS_FINAL
series: [ {"series": 'reset', "tooltip": '{{tooltip1}}<br>{{tooltip2}}<br>{{tooltip3}}'} ],
htmlToolTip: {enable: true, snap: false }
*END
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getY1Title(),false);
setDisplay(getY1Label(),false);
setDisplay(getY1AxisLine(),false);
setLabelStagger(getO1Label(),true);
setTextRotation(getO1Label(),3);
*END

*GRAPH_JS_FINAL
"xaxis": {
    "title": {"visible": false}
},
"yaxis": {
    "title": {"visible": false},
    "majorGrid": {"ticks": {"visible": false}}
}
*END
ENDSTYLE
END
-RUN