Focal Point
Pareto Charts

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

March 19, 2008, 04:09 PM
Gizmo
Pareto Charts
How can I do a Pareto Chart and not have a rank field prefixed on the sort?

eg
TABLE FILE CAR
SUM SALES
RANKED AS RANK
BY TOTAL HIGHEST SALES
BY COUNTRY
END

DEFINE FILE HOLD
RANK/I2 = RANK;
COUNTRY2/A40 = EDIT(RANK) || COUNTRY;
END

GRAPH FILE HOLD
SUM SALES
BY COUNTRY2
ON GRAPH SET LOOKGRAPH PARETO
...
END




Windows: WF 7.6.2: SQL Server 2008 R2
March 19, 2008, 04:46 PM
GinnyJakes
TABLE FILE CAR
SUM SALES
RANKED AS RANK
BY TOTAL HIGHEST SALES
BY COUNTRY
ON TABLE HOLD FORMAT ALPHA
END
TABLE FILE HOLD
PRINT COUNTRY
BY RANK NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE
END

-RUN
-SET &LIM=&LINES;
-SET &I=0;
-REPEAT GRAPH &LIM TIMES
-READ SAVE NOCLOSE &COUNTRY.A10.
-IF &RETCODE NE 0 GOTO GRAPH;
-SET &I=&I+1;
-SET &COUNTRY.&I=&COUNTRY;
-TYPE &I &COUNTRY.&I

-GRAPH
DEFINE FILE HOLD
RANK/I2 = RANK;
COUNTRY2/A40 = EDIT(RANK) || COUNTRY;
END

GRAPH FILE HOLD
SUM SALES
BY COUNTRY2
ON GRAPH SET LOOKGRAPH PARETO
ON GRAPH SET GRAPHSTYLE *
-SET &I=1;
-SET &J=0;
-REPEAT ENDGROUP &LIM TIMES
setGroupLabel(&J,"&COUNTRY.&I");
-SET &I=&I+1;
-SET &J=&J+1;
-ENDGROUP
ENDSTYLE
END


This should work for you.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
March 19, 2008, 05:52 PM
Gizmo
Thanks Ginny,

This works great!



Windows: WF 7.6.2: SQL Server 2008 R2