I am creating a pie chart that needs to show the top 5 results and then group the rest of the results into its own slice. I have tried using OtherSeries on this and its not working. It doesn't group them at all. Any help would be appreciated.

GRAPH FILE LOAN_EXC

SUM LOAN_EXC.LOAN_EXC.FAILURE_COUNT AS "Failure Count"
BY LOAN_EXC.LOAN_EXC.DYNAMIC_ERROR_MESSAGE_TXT AS "Error"

ON GRAPH PCHOLD FORMAT JSCHART
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 PIEMULTI
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setGraphType(55);
setOtherSeries(true);
setOtherPercentage(10.0);
value = getOtherPercentage();
setDisplay(getPieOtherFrame(),true);
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setPieFeelerTextDisplay(1);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-*IA_GRAPH_FINISH

This message has been edited. Last edited by: <Kathryn Henning>,

With the PLUS OTHERS phrase, you can aggregate all other values to a separate group and display this group as an additional report row.

GRAPH FILE CAR
SUM DEALER_COST 
  BY HIGHEST 5 CAR
  PLUS OTHERS AS 'Others'
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setGraphType(55);
setOtherSeries(true);
setOtherPercentage(10.0);
value = getOtherPercentage();
setDisplay(getPieOtherFrame(),true);
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 
setPieFeelerTextDisplay(1); 
*END
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END

Hi,
OtherSeries will not work in JSCHART format.
You would have to use JSON code.
Here is an example of adding otherSlice in JSCHART output format:

ENGINE INT CACHE SET ON

GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM SALES
BY MODEL
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setPieFeelerTextDisplay(1);

*END

*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
*GRAPH_JS
dataLabels: {visible:true},
pieProperties: {otherSlice:
{threshold: '7%',
legendLabel: 'OTHER',
color: 'blue',
}
},
legend: {visible:true},
interaction:{
click: 'otherSliceDrillDown'
} ,

*END
ENDSTYLE
END

-RUN

Fantastic! Thanks for the great advice