Jump to content
We've recently updated our Privacy Statement, available here. ×

Super simple question on pie charts I can't believe I'm getting tripped up on this!


Jeff Hanson---LEFT

Recommended Posts

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?!

Link to comment
Share on other sites

I was able to create this in InfoAssistimage.thumb.png.153174bb11a5596df158cd2002ddc5ce.pngThe 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
Link to comment
Share on other sites

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
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...