[SOLVED] Display two measures on hover tool tip

October 12, 2019, 06:15 PM

BI Dev

Hi,

I have two measures plotted on a bar graph, I would like to display these two measures on the tool tip whenever someone hovers on any of these bars be it measure 1 bar or measure 2 bar. I have tried doing this, but did not get the needed result. Please find my code below and post your thoughts and inputs if you have any. Thank you in advance.

GRAPH FILE CAR
SUM 
RETAIL_COST
DEALER_COST
COMPUTE RETAIL_COST1/D7=RETAIL_COST;
COMPUTE DEALER_COST1/D7=DEALER_COST;
BY COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS PIXELS
ON GRAPH SET HAXIS 700
ON GRAPH SET VAXIS 400
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=RETAIL_COST1, BUCKET=tooltip, $
TYPE=DATA, COLUMN=DEALER_COST1, BUCKET=tooltip, $
*GRAPH_JS_FINAL
series: [ {"series": 'reset', "tooltip":"Retail:"+ '{{tooltip1}}'}]
-*<br>"Dealer:"+{{tooltip2}}'} ]
-*,
-*htmlToolTip: {enable: true, snap: false }
*END
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDataTextPosition(4);
setDataTextDisplay(true);
setDisplay(getLegendArea(),true);
*END
ENDSTYLE
END
-RUN

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

October 15, 2019, 10:47 AM

Frans

GRAPH FILE CAR
SUM 
RETAIL_COST
DEALER_COST
COMPUTE RETAIL_COST1/D7=RETAIL_COST;
COMPUTE DEALER_COST1/D7=DEALER_COST;
BY COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS PIXELS
ON GRAPH SET HAXIS 700
ON GRAPH SET VAXIS 400
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=RETAIL_COST1, BUCKET=tooltip, $
TYPE=DATA, COLUMN=DEALER_COST1, BUCKET=tooltip, $
*GRAPH_JS_FINAL
series: [ {"series": 'reset', "tooltip":"Retail:"+ '{{tooltip1}}'+'<br>Dealer:'+'{{tooltip2}}'} ]
-*,
-*htmlToolTip: {enable: true, snap: false }
*END
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDataTextPosition(4);
setDataTextDisplay(true);
setDisplay(getLegendArea(),true);
*END
ENDSTYLE
END
-RUN