*GRAPH_SCRIPT setTextFormatPreset(getDataText(),0); setDisplay(getY1Title(),false); setPlaceResize(getY2Title(),0); setFontStyle(getY2Title(),2); setFontSizeAbsolute(getY1Label(),true); setFontSizeInPoints(getY1Label(),9); setFontSizeAbsolute(getY2Label(),true); setFontSizeInPoints(getY2Label(),9); setPlaceResize(getY1Label(),0); setTextFormatPattern(getY1Label(),"#%"); setTextFormatPreset(getY1Label(),28); setTextString(getY2Title(),"Dollars"); setDisplay(getY2Title(),false); setTextFormatPreset(getY2Label(),-1); setTextFormatPattern(getY2Label(),"$#"); setDataTextDisplay(true); setSeriesLabel(0,"Percent"); setSeriesLabel(1,"Dollars"); setAxisAssignment( $0, 0); setAxisAssignment( $1, 1); setDisplay(getO1MajorGrid(),false); setGridStepAuto(getY2MajorGrid(),false); setGridStep(getY2MajorGrid(),6) setAltFmtFrameNumColors(getY2AltFmtFrame(),5); setScaleMax(getY1Axis(),100.0); setGridStepAuto(getY1MajorGrid(),false); setGridStep(getY1MajorGrid(),20.0); setDisplay(getDataText(0),true); setDisplay(getDataText(1),true); setDataTextPosition(1); setTextFormatPattern(getDataText(0),"#%"); setTextFormatPreset(getDataText(),28); setDataTextPosition(1); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(),6);
https://webfocusinfocenter.inf...s/source/02_3d31.htm.
setDataTextPosition(1); setTextFormatPattern(getDataText(0),"#%"); setTextFormatPreset(getDataText(),28); setDataTextPosition(1); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(),6);
setDataTextPosition(1); setTextFormatPattern(getDataText(0),"#%"); setTextFormatPreset(getDataText(0),28); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(1),6);
GRAPH FILE CAR SUM COMPUTE PCT /P6 = (RETAIL_COST - DEALER_COST) / RETAIL_COST * 100; DEALER_COST BY CAR 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 GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET LOOKGRAPH VBAR2AX 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, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setPieFeelerTextDisplay(1); setDisplay(getY1Title(),false); setPlaceResize(getY2Title(),0); setFontStyle(getY2Title(),2); setFontSizeAbsolute(getY1Label(),true); setFontSizeInPoints(getY1Label(),9); setFontSizeAbsolute(getY2Label(),true); setFontSizeInPoints(getY2Label(),9); setPlaceResize(getY1Label(),0); setTextFormatPattern(getY1Label(),"#%/100"); setTextFormatPreset(getY1Label(),28); setTextString(getY2Title(),"Dollars"); setDisplay(getY2Title(),false); setTextFormatPreset(getY2Label(),-1); setTextFormatPattern(getY2Label(),"$#"); setSeriesLabel(0,"Percent"); setSeriesLabel(1,"Dollars"); setAxisAssignment( $0, 0); setAxisAssignment( $1, 1); setDisplay(getO1MajorGrid(),false); setGridStepAuto(getY2MajorGrid(),false); setGridStep(getY2MajorGrid(),6) setAltFmtFrameNumColors(getY2AltFmtFrame(),5); setScaleMax(getY1Axis(),100.0); setGridStepAuto(getY1MajorGrid(),false); setGridStep(getY1MajorGrid(),20.0); setDataTextDisplay(true); setDisplay(getDataText(0),true); setDisplay(getDataText(1),true); setDataTextPosition(1); setTextFormatPattern(getDataText(0),"#%/100"); setTextFormatPreset(getDataText(0),28); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(1),6); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "agnosticSettings": { "dual": true, "chartTypeFullName": "Bar_Clustered_Dual_Axis" } *END ENDSTYLE END -RUN
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
quote:Then, I'll push this a bit and ask if it can be done within InfoAssist.
setUseSeriesShapes(true); setMarkerSizeDefault(50); setReportParsingErrors(false); setSelectionEnableMove(false); setPieFeelerTextDisplay(1); setDepthAngle(45); setPieTilt(10); setPieDepth(70); setDepthRadius(0); setTextFormatPreset(getDataText(),0); setDisplay(getY1Title(),false); setFontName(getY1Label(),"Calibri"); setFontName(getY2Title(),"Calibri"); setFontName(getY2Label(),"Calibri"); setFontName(getDataText(),"Calibri"); setFontName(getO1Title(),"Calibri"); setFontName(getX1Title(),"Calibri"); setFontName(getSubtitle(),"Calibri"); setFontName(getAllText(),"Calibri"); setFontSizeAbsolute(getY2Title(),true); setFontSizeInPoints(getY2Title(),9); setPlaceResize(getY2Title(),0); setFontStyle(getY2Title(),2); setFontSizeAbsolute(getY1Label(),true); setFontSizeInPoints(getY1Label(),9); setFontSizeAbsolute(getY2Label(),true); setFontSizeInPoints(getY2Label(),9); setPlaceResize(getY1Label(),0); setTextFormatPattern(getY1Label(),"#%"); setTextFormatPreset(getY1Label(),28); setTextFormatPreset(getY2Label(),-1); setTextFormatPattern(getY2Label(),"$#"); setDisplay(getLegendArea(),false); setDisplay(getLegendArea(),true); setFontName(getLegendText(),"Calibri"); setFontSizeAbsolute(getLegendText(),true); setFontSizeInPoints(getLegendText(),9); setPlaceResize(getLegendText(),0); setDataTextDisplay(true); setSeriesLabel(0,"Percent"); setSeriesLabel(1,"Dollars"); setAxisAssignment( $0, 0); setAxisAssignment( $1, 1); setDisplay(getO1MajorGrid(),false); setGridStepAuto(getY2MajorGrid(),false); setGridStep(getY2MajorGrid(),6) setAltFmtFrameNumColors(getY2AltFmtFrame(),5); setDisplay(getY1MajorGrid(),false); setDisplay(getY2MajorGrid(),false); setDisplay(getO1MajorGrid(),false); setScaleMax(getY1Axis(),100.0); setGridStepAuto(getY1MajorGrid(),false); setGridStep(getY1MajorGrid(),20.0); setDisplay(getDataText(0),true); setDisplay(getDataText(1),true); setDataTextPosition(1); -*The code below is what I had that gave me dollar signs only for both data labels above the bars. I did eliminate the duplicate setDataTextPosition(1) line you referenced earlier. -*setTextFormatPattern(getDataText(0),"#%"); -*setTextFormatPreset(getDataText(),28); -*setTextFormatPattern(getDataText(1),"$#"); -*setTextFormatPreset(getDataText(),6); -*The code you provided. setTextFormatPattern(getDataText(0),"#%"); setTextFormatPreset(getDataText(0),28); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(1),6);
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='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE CAR SUM COMPUTE PCT /P6C = (RETAIL_COST - DEALER_COST) / RETAIL_COST * 100; DEALER_COST BY CAR 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 GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET LOOKGRAPH VBAR2AX 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, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setAxisAssignment( $0, 0); setAxisAssignment( $1, 1); setFontName(getAllText(),"Calibri"); setFontName(getSubtitle(),"Calibri"); setFontName(getDataText(),"Calibri"); setFontName(getO1Title(),"Calibri"); setFontName(getO1Label(),"Calibri"); setFontName(getY1Label(),"Calibri"); setFontName(getY2Label(),"Calibri"); setFontName(getLegendText(),"Calibri"); setDisplay(getLegendArea(),true); setPlaceResize(getLegendText(),0); setFontSizeAbsolute(getLegendText(),true); setFontSizeInPoints(getLegendText(),9); setSeriesLabel(0,"Percent"); setDisplay(getY1Title(),false); setFontSizeAbsolute(getY1Label(),true); setFontSizeInPoints(getY1Label(),9); setTextFormatPattern(getY1Label(),"#%/100"); setTextFormatPreset(getY1Label(),28); setSeriesLabel(1,"Dollars"); setDisplay(getY2Title(),false); setFontSizeAbsolute(getY2Label(),true); setFontSizeInPoints(getY2Label(),9); setTextFormatPattern(getY2Label(),"$#"); setTextFormatPreset(getY2Label(),7); setDataTextPosition(1); setDisplay(getDataText(0),true); setTextFormatPattern(getDataText(0),"#%/100"); setTextFormatPreset(getDataText(0),28); setDisplay(getDataText(1),true); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPreset(getDataText(1),6); setDisplay(getO1MajorGrid(),false); setScaleMax(getY1Axis(),100.0); setGridStepAuto(getY1MajorGrid(),false); setGridStep(getY1MajorGrid(),20.0); *GRAPH_JS_FINAL "agnosticSettings": { "dual": true, "chartTypeFullName": "Bar_Clustered_Dual_Axis" } *END ENDSTYLE END -RUN
ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET EMBEDHEADING ON ON GRAPH SET VZERO OFF ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET LOOKGRAPH VBAR2AX ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setCurveFitEquationDisplay(false); setPlace(true); *END INCLUDE=stylesheet here, TYPE=REPORT, TITLETEXT='WebFOCUS Report', ORIENTATION=LANDSCAPE, $ TYPE=HEADING, JUSTIFY=LEFT, FONT='Calibri', SIZE=10, COLOR=RGB(0 0 0), STYLE=BOLD, $ TYPE=FOOTING, JUSTIFY=RIGHT, FONT='Calibri', SIZE=8, COLOR=RGB(0 0 0), STYLE=NORMAL, $ *GRAPH_SCRIPT setUseSeriesShapes(true); setMarkerSizeDefault(50); setReportParsingErrors(false); setSelectionEnableMove(false); setDepthAngle(45); setPieTilt(10); setPieDepth(70); setDepthRadius(0); setTextFormatPreset(getDataText(),0); setDisplay(getY1Title(),false); setFontName(getY1Label(),"Calibri"); setFontName(getY2Title(),"Calibri"); setFontName(getY2Label(),"Calibri"); setFontName(getDataText(),"Calibri"); setFontName(getO1Title(),"Calibri"); setFontName(getX1Title(),"Calibri"); setFontName(getSubtitle(),"Calibri"); setFontName(getAllText(),"Calibri"); setFontSizeAbsolute(getY2Title(),true); setFontSizeInPoints(getY2Title(),9); setPlaceResize(getY2Title(),0); setFontStyle(getY2Title(),2); setFontSizeAbsolute(getY1Label(),true); setFontSizeInPoints(getY1Label(),9); setFontSizeAbsolute(getY2Label(),true); setFontSizeInPoints(getY2Label(),9); setPlaceResize(getY1Label(),0); setTextFormatPreset(getY1Label(),28); setTextString(getY2Title(),"Dollars"); setDisplay(getY2Title(),false); setTextFormatPreset(getY2Label(),-1); setTextFormatPattern(getY2Label(),"$#"); setDisplay(getLegendArea(),false); setDisplay(getLegendArea(),true); setFontName(getLegendText(),"Calibri"); setFontSizeAbsolute(getLegendText(),true); setFontSizeInPoints(getLegendText(),9); setPlaceResize(getLegendText(),0); setDataTextDisplay(true); setDisplay(getDataText(),false); setTextFormatPattern(getDataText(1),"$#"); setTextFormatPattern(getDataText(0),"#.#%"); setDisplay(getDataText(1), false); setDisplay(getDataText(0),false); setTextFormatPreset(getDataText(1),6); setTextFormatPreset(getDataText(0),3); setSeriesLabel(0,"Percent"); setSeriesLabel(1,"Dollars"); setAxisAssignment( $0, 0); setAxisAssignment( $1, 1); setDisplay(getO1MajorGrid(),false); setGridStepAuto(getY2MajorGrid(),false); setGridStep(getY2MajorGrid(),6) setAltFmtFrameNumColors(getY2AltFmtFrame(),5); setDisplay(getY1MajorGrid(),false); setDisplay(getY1MajorGrid(),false); setDisplay(getY2MajorGrid(),false); setDisplay(getO1MajorGrid(),false); setScaleMax(getY1Axis(),100.0); setGridStepAuto(getY1MajorGrid(),false); setGridStep(getY1MajorGrid(),20.0); *END ENDSTYLE END -*IA_GRAPH_FINISH -RUN
quote:Originally posted by Doug:
This leads me to ask: How can we get the value to be display 'On Hover' to match the value displayed at the top of the bars. In this example The values display On Hover are the same but missing the percent sign / currency symbol.
IMHO: The values displayed should be the same in all cases.
I do appreciate the use of the two 'setSeriesLabel' statements to show 'Dollars' and 'Percent'.
Then, I'll push this a bit and ask if it can be done within InfoAssist.