GRAPH FILE CAR SUM SALES RETAIL_COST DEALER_COST BY COUNTRY ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET LOOKGRAPH EXTENSION ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setPlace(true); setCurveFitEquationDisplay(false); *END TYPE=DATA, COLUMN=N1, BUCKET= >group, $ TYPE=DATA, COLUMN=N2, BUCKET= >keymeasure, $ TYPE=DATA, COLUMN=N3, BUCKET= >measure, $ TYPE=DATA, COLUMN=N4, BUCKET= >measure, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); *GRAPH_JS "pieProperties": { "holeSize": "0%" }, "chartType": "com.ibi.kpi.table", "agnosticSettings": { "chartTypeFullName": "com.ibi.kpi.table" } *END ENDSTYLE END -RUNThis message has been edited. Last edited by: FP Mod Chuck,
*GRAPH_JS_FINAL "extensions": { "com.ibi.kpi.table": { "color": "#666", "shortenNumbers": true, "fontFamily": "'Open Sans'", "fontSize": "12px", "headingTitle": { "fontWeight": "400", "color": "inherit", "fontSize": "16px" }, "headingData": { "fontWeight": "700", "color": "inherit", "fontSize": "24px" }, "columnTitle": { "fontWeight": "400", "color": "inherit", "fontSize": "14px" }, "columnData": { "fontWeight": "700", "color": "inherit", "fontSize": "16px" } } } *END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:You could accomplish the same results by placing the appropriate TITLEs and DATA elements in a multiline HEADING, formatted as needed, using a simple TABLE FILE request.
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
GRAPH FILE CAR SUM SALES RETAIL_COST DEALER_COST BY COUNTRY ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET LOOKGRAPH EXTENSION ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setPlace(true); setCurveFitEquationDisplay(false); *END TYPE=DATA, COLUMN=N1, BUCKET= >group, $ TYPE=DATA, COLUMN=N2, BUCKET= >keymeasure, $ TYPE=DATA, COLUMN=N3, BUCKET= >measure, $ TYPE=DATA, COLUMN=N4, BUCKET= >measure, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); -*-* Changes the background-color to green setFillColor(getChartBackground(),new Color(0,100,0)); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "chartType": "com.ibi.kpi.table", "agnosticSettings": { "chartTypeFullName": "com.ibi.kpi.table" }, "extensions": { "com.ibi.kpi.table": { "color": "#ffffff", // changes color to white "shortenNumbers": true, "fontFamily": "'Open Sans'", "fontSize": "17px", // only effects the 'group' bucket because of how the heading and column font-sizes are set "headingTitle": { "fontWeight": "400", "color": "inherit", "fontSize": "16px" }, "headingData": { "fontWeight": "700", "color": "inherit", "fontSize": "24px" }, "columnTitle": { "fontWeight": "400", "color": "inherit", "fontSize": "14px" }, "columnData": { "fontWeight": "700", "color": "inherit", "fontSize": "16px" } } } *END ENDSTYLE END
quote:Doug, Have you tried a KPI.TABLE chart? It does more than what you are suggesting.
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
I'll check out the configuration first.quote:8204M Gen48
*TABLE_STYLE TYPE=REPORT, GRID=OFF, FONT='Open Sans', SIZE=9, STYLE=NORMAL, SQUEEZE=ON, COLOR=RGB(238 238 238), PAGECOLOR=RGB(#480C55), BACKCOLOR=RGB(#480C55), TITLELINE=SKIP, $ *END *GRAPH_STYLE TYPE=REPORT, GRID=OFF, FONT='Open Sans', SIZE=9, STYLE=NORMAL, SQUEEZE=ON, COLOR=RGB(238 238 238), PAGECOLOR=RGB(#480C55), BACKCOLOR=RGB(#480C55), TITLELINE=SKIP, $ *END *GRAPH_SCRIPT setTransparentBorderColor(getChartBackground(),true); setFillColor(getChartBackground(),new Color(255,255,255,0)); *GRAPH_JS_FINAL "extensions":{ "com.ibi.kpi.sparkline":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", "badColor": "#eee" } }, "com.ibi.kpi.sparkline2":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", } }, "com.ibi.kpi.table":{ "color": "#eee" }, "com.ibi.kpi.dashboard":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", "badColor": "#eee" } } } *END
*TABLE_STYLE TYPE=REPORT, GRID=OFF, FONT='Open Sans', SIZE=9, STYLE=NORMAL, SQUEEZE=ON, COLOR=RGB(238 238 238), PAGECOLOR=RGB(#080A5A), BACKCOLOR=RGB(#080A5A), TITLELINE=SKIP, $ *END *GRAPH_STYLE TYPE=REPORT, GRID=OFF, FONT='Open Sans', SIZE=9, STYLE=NORMAL, SQUEEZE=ON, COLOR=RGB(238 238 238), PAGECOLOR=RGB(#080A5A), BACKCOLOR=RGB(#080A5A), TITLELINE=SKIP, $ *END *GRAPH_SCRIPT setTransparentBorderColor(getChartBackground(),true); setFillColor(getChartBackground(),new Color(255,255,255,0)); *GRAPH_JS_FINAL "extensions":{ "com.ibi.kpi.sparkline":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", "badColor": "#eee" } }, "com.ibi.kpi.sparkline2":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", } }, "com.ibi.kpi.table":{ "color": "#eee" }, "com.ibi.kpi.dashboard":{ "type": "bar", "color": "#eee", "barProperties": { "goodColor": "#eee", "badColor": "#eee" } } } *END