Focal Point
[SOLVED] Graph Issue

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

October 30, 2017, 04:40 PM
Doug
[SOLVED] Graph Issue
Why does the following code show a split graph when "ITEM3" is DEFINEd as 100 but not when it's DEFINEd as 800+?
I need to use this as an HTMTABLE.
DEFINE FILE CAR
ITEM1/I3=900;
ITEM2/I3=800;
ITEM3/I3=700;
END
GRAPH FILE CAR
SUM ITEM1 ITEM2 ITEM3
BY CAR.ORIGIN.COUNTRY AS '' NOPRINT
WHERE RECORDLIMIT EQ 1;
-*ON GRAPH PCHOLD FORMAT JSCHART
-*ON GRAPH HOLD FORMAT HTMTABLE AS GRAPH856
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET HAXIS 800.0
ON GRAPH SET VAXIS 60.0
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, JUSTIFY=center, FONT='TAHOMA', SIZE=8 COLOR=RED, TITLETEXT=&WF_TITLE.QUOTEDSTRING, GRID=OFF, BORDER=LIGHT, $
TYPE=DATA, STYLE=normal, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),false);
setFontName(getLegendText(), "Arial");
setFontSizeVC(getLegendText(), 1130);
setGridStepAuto(getY1MajorGrid(),false);
setDataTextPosition(5);
setDataTextDisplay(true);
setPieFeelerTextDisplay(1);
setY1AxisSide(3);
setGridStep(getY1MajorGrid(),20.0);
setTextFormatPreset(getDataText(),0);
setTextFormatPreset(getY1Label(),-2);
setDisplay(getY1Label(),false);
setDisplay(getO1Label(),false);
setTextFormatPattern(getDataText(),"###");
*GRAPH_JS_FINAL
"blaProperties": {
    "orientation": "horizontal"
},
"agnosticSettings": {
    "chartTypeFullName": "Bar_Clustered_Horizontal"
}
*END
ENDSTYLE
END
-RUN

BONUS Question: How do I make the values, shown in the BARs larger?

Thanks in Advance, Doug

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
October 30, 2017, 04:59 PM
Doug
I get the BONUS. Add the following lines. This isn't very intuitive in the GUI, is it?
setFontSizeAbsolute(getDataText(),true);
setAutofit(getDataText(),false);
setFontSizeInPoints(getDataText(),8);
setPlaceResize(getDataText(),0);

October 31, 2017, 09:21 AM
Doug
I got it: setScaleMax(getY1Axis(),1000.0);