Focal Point
[WORKAROUND] Display percent in pie chart legend

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5641097892

September 09, 2008, 11:13 AM
Doug
[WORKAROUND] Display percent in pie chart legend
I'm sure that the percent associated with a pie slice can be displayed in the legend of a pie chart. However, I cannot get it to do so in the Advanced Graph Assistant. Would someone please let me know how to accomplish this?
Thanks in Advance
-Doug

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
September 09, 2008, 11:27 AM
<JG>
No it can't unfortunately.

You can not display data values in a legend

A possible trick is to actually concat the data value to the sort key

so for example

TABLE FILE CAR
SUM PCT.DEALER_COST
COMPUTE CAR_PCT/A50= CAR || ' ' | FTOA(C1,'D12.2%','A15'); NOPRINT
BY TOTAL CAR_PCT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD
END
-RUN
GRAPH FILE HOLD
SUM DEALER_COST
ACROSS CAR_PCT
etc.
September 09, 2008, 11:38 AM
Doug
Thanks JG,

That's what I thought... I'll check it out as per your suggestion. "They" want the legend to show the percent as well as the field. So, that's what they'll get.

-Doug