I've been reqeusted to to build a Statistical Distribution graph or box plot of cycle time data. I know I need to calculate the median, upper and lower quartiles, and the minimum and maximum data values. The actual display has been the chanlleng. Any suggestions out there?

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

are you going to Summit, Laure?

Yes. I'm looking forward to it.

ok, catch up with me there and we'll discuss.

Laure,

Do you have a sample of what you desire to achieve which you can post? Maybe even a link to an Excel file? GIF? JPG?

Doug

GRAPHTYPE(124) GENERATES A BOX PLOT.

This can not be done via the GUI however.
An API call to set the graphtype
and then ensure you have 5 data points to graph

Min, Max, Median, 1 and 3rd quartiles.

Here's a sample against the CAR file that I received from Vicky Lozovksy.

 DEFINE FILE CAR
 Median/D12.2=( CAR.BODY.DEALER_COST + CAR.BODY.RETAIL_COST ) / 2;
 UL/D12.2=CAR.BODY.RETAIL_COST + ( CAR.BODY.RETAIL_COST  / 5) ;
 LL/D12.2=CAR.BODY.DEALER_COST - ( CAR.BODY.DEALER_COST  / 5) ;
END
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
Median
UL
LL
BY COUNTRY
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
-*ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setGraphType(124);
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setPlace(true); 
setTransparentBorderColor(getChartBackground(),true); 
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setDepthAngle(0);
setDisplay(getY1MajorGrid(),false);
setDisplay(getO1MajorGrid(),false);
ENDSTYLE
END
 

Thanks Laure,

This is what we spkoe about at Summit... I like it!

Is there any way to make the bars horizontal instead of vertical?

I don't know of one. Vicky is your best bet.

Vicky who?

Tom, the Boxplot graph type is documented in the link. I recieved the info from Vicky Lozovksy of IBI at Summit last year. She preseneted a session on graphing. Don't know if it will ever be fully documented, but it is available.


Graphtype(124)

Hi Laure and Gang,

Thanks. I did not search for that particular Graphtype, and, it is not in the WebFOCUS Graphics manual either. So, maybe Meghan will try other numbers around that series for her task!

Say Hi to all! Cold in Florida? Must be Global Warming!!!

EDIT: It is not documented in the Perspective For Java Manual, either!!! Perspective for Java

This message has been edited. Last edited by: Tom Flynn,

Thanks all. I'll try and ping Vicky to see what she has to say. I did try other random numbers around 124 (all the way to 140 actually) with no luck. And yes, sadly this graph type is not documented anywhere.

Just FYI: Check out "boxplots" in WebFOCUS HELP (F1)... It's there now... Not too verbose. But, quite adequate.