Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.
One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.
gb2 = dt << Graph Builder(
Size( 1065, 516 ),
Show Control Panel( 0 ),
Variables( Y( :Sales ), Group X( :Month ) ),
Elements(
Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ),
Line( Y, Legend( 7 ) ),
Caption Box( Y, Legend( 9 ) )
),
SendToReport(
Dispatch(
{},
"Sales",
ScaleBox,
{Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )}
),
)
);
bpseg = gb2 << Xpath("//BoxPlotSeg");
bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )};
//if you want to color each by month
for(i=1, i<=nitems(bpseg), i++,
bpseg[i] << Fill Color(Color Of(As Row State(cc[i])))
);The full script is attached.
***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish
- Concatenate the original table and the table summary.
- Add a column called Means that is really the positon where you want the means to appear.
- Make the Mean(Sales) column a label.
- Plot both Sales and Means versus Month
- Move Mean sales to the right and align tick marks
- Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
- Change the Points on the right to a bar style single and Label ("Label by Row")
@gzmorgan0 wrote:Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.
One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.
@gzmorgan0 wrote:Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.
One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.
gb2 = dt << Graph Builder( Size( 1065, 516 ), Show Control Panel( 0 ), Variables( Y( :Sales ), Group X( :Month ) ), Elements( Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ), Line( Y, Legend( 7 ) ), Caption Box( Y, Legend( 9 ) ) ), SendToReport( Dispatch( {}, "Sales", ScaleBox, {Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )} ), ) ); bpseg = gb2 << Xpath("//BoxPlotSeg"); bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )}; //if you want to color each by month for(i=1, i<=nitems(bpseg), i++, bpseg[i] << Fill Color(Color Of(As Row State(cc[i]))) );The full script is attached.
***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish
- Concatenate the original table and the table summary.
- Add a column called Means that is really the positon where you want the means to appear.
- Make the Mean(Sales) column a label.
- Plot both Sales and Means versus Month
- Move Mean sales to the right and align tick marks
- Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
- Change the Points on the right to a bar style single and Label ("Label by Row")
You can add as much caption boxes as you want by drag & drop. By default they are displaying the mean. This however can be changed to Std Dev, N etc.
However, in case of the mean, I prefer to show him at the box plot.
gb2 = dt << Graph Builder( Size( 1065, 516 ), Show Control Panel( 0 ), Variables( Y( :Sales ), Group X( :Month ) ), Elements( Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ), Line( Y, Legend( 7 ) ), Caption Box( Y, Legend( 9 ) ) ), SendToReport( Dispatch( {}, "Sales", ScaleBox, {Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )} ), ) ); bpseg = gb2 << Xpath("//BoxPlotSeg"); bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )}; //if you want to color each by month for(i=1, i<=nitems(bpseg), i++, bpseg[i] << Fill Color(Color Of(As Row State(cc[i]))) );The full script is attached.
***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish
- Concatenate the original table and the table summary.
- Add a column called Means that is really the positon where you want the means to appear.
- Make the Mean(Sales) column a label.
- Plot both Sales and Means versus Month
- Move Mean sales to the right and align tick marks
- Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
- Change the Points on the right to a bar style single and Label ("Label by Row")
@DANN, are the 4 columns responses (results) of the experiment or factors (input) for the design?
As your table is setup, it would take a custom function to connect the box medians, since you have no Y variable. I am going to use the JMP sample data Iris.JMP to emulate your data and the steps.
If using the UI (point and click):
- Select Tables > Stack choose your 4 columns as the Stack Columns, change the names (Data and Label) if you like and select OK. Data will be the values of the 4 columns and Values will be the column names. For your example a better name than label might be Factors or Responses.
- Now select Graphs > Graphbuilder and drag Data to the Y column and Label to the X column.
- Right Click and select Box Plots and Line and select the Summary Statistics to be Median
Here is a picture of the Iris data table after following the instructions above
Without stacking the data, I can only provide a JSL solution. My earlier post/example had one or multiple columns for Y and and a categorical X (Months). The elements Line or Smoother need both and X and Y. There is another graph called the parallel plot that would be appropriate if your 4 columns were responses to an experiment. Each of the 20 lines would represent a "profile" of each experimental trial's results.
Hope that helps.
Community Manager
This is easily done interactively.
Start with the box plots turned on. Then click and drag the points element into the graph. Change the summary statistic for the points to mean. Then drag the line element into the graph.
