Jeff Hanson---LEFT Posted July 17, 2023 Posted July 17, 2023 I have a table of raw data consisting of test results for several production batches. It includes the test parameters and the test results. I've created a cross table and used a custom expression to calculate the Cpk for each test parameter and assign Red, Yellow, Green into a column. Now I want to create a pie chart with slices for Red, Yellow and Green. How do I do this?!
David Beagan Posted July 18, 2023 Posted July 18, 2023 I was able to create this in InfoAssistThe code looks like this:ENGINE INT CACHE SET ONSET PAGE-NUM=NOLEAD-DEFAULTH &WF_HTMLENCODE=ON;SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART-DEFAULTH &WF_EMPTYREPORT=ON;SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ONSET GRAPHDEFAULT=OFF-DEFAULTH &WF_ARVERSION=2;SET ARVERSION=&WF_ARVERSION -DEFAULTH &WF_STYLE_UNITS='PIXELS';-DEFAULTH &WF_STYLE_HEIGHT='405.0';-DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report';GRAPH FILE ibisamp/ggsales-* Created by Info Assist for GraphSUM GGSALES.SALES01.UNITSBY GGSALES.SALES01.REGIONWHERE GGSALES.SALES01.REGION NE 'West';ON GRAPH PCHOLD FORMAT JSCHARTON GRAPH SET VZERO OFFON GRAPH SET UNITS &WF_STYLE_UNITSON GRAPH SET HAXIS &WF_STYLE_WIDTHON GRAPH SET VAXIS &WF_STYLE_HEIGHTON GRAPH SET LOOKGRAPH PIEON GRAPH SET AUTOFIT ONON GRAPH SET STYLE **GRAPH_SCRIPT setPieDepth(0);setPieTilt(0);setDepthRadius(0);setCurveFitEquationDisplay(false);setPlace(true);setPieFeelerTextDisplay(1); *ENDINCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $TYPE=DATA, COLUMN=N1, BUCKET=color, $TYPE=DATA, COLUMN=N2, BUCKET=measure, $*GRAPH_SCRIPT setReportParsingErrors(false);setSelectionEnableMove(false);setFillColor(getSeries(3),new Color(252,66,14));setFillColor(getSeries(0),new Color(250,255,52));setFillColor(getSeries(1),new Color(255,0,0));*GRAPH_JS_FINAL"pieProperties": {"holeSize": "0%"},"agnosticSettings": {"chartTypeFullName": "Pie_Multi"} *ENDENDSTYLEEND -RUN
David Beagan Posted July 18, 2023 Posted July 18, 2023 Maybe this is better:GRAPH FILE CARSUM HEIGHT AS ''ACROSS COUNTRY AS ''WHERE COUNTRY LT 'JAPAN'ON GRAPH PCHOLD FORMAT JSCHARTON GRAPH SET LOOKGRAPH PIEON GRAPH SET AUTOFIT ONON GRAPH SET STYLE **GRAPH_JSseries: [ {series: 0, color: 'red'}, {series: 1, color: 'yellow'}, {series: 2, color: 'green'},],*ENDENDSTYLEEND
Jeff Hanson---LEFT Posted July 18, 2023 Author Posted July 18, 2023 Interesting... I don't know anything about InfoAssist or it's licensing. Also, If the category I want to chart was part of my native data set I think it would be easy but here I am calculating a column of colors using a custom expression and I want to pie chart the values in this calculated column.
David Beagan Posted July 18, 2023 Posted July 18, 2023 Maybe you could explain a bit more about what you are trying to do.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now