Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Graph PieChart Group by "Not in top 5" trouble

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Graph PieChart Group by "Not in top 5" trouble
 Login/Join
 
Member
posted
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>,


WebFOCUS 8.02
Windows, All Outputs
 
Posts: 5 | Registered: August 28, 2013Report This Post
Silver Member
posted Hide Post
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



WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
 
Posts: 40 | Registered: April 02, 2014Report This Post
<nick z>
posted
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
 
Report This Post
Member
posted Hide Post
Fantastic! Thanks for the great advice Smiler


WebFOCUS 8.02
Windows, All Outputs
 
Posts: 5 | Registered: August 28, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Graph PieChart Group by "Not in top 5" trouble

Copyright © 1996-2020 Information Builders