cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

How can I classify data when I make box-plot?

Hi guys.

 

I would like to make box chart like below picture.

SpendingRootCat_0-1738625621777.png

Raw data are length and width data by production date

SpendingRootCat_1-1738625756018.png

 

In above chart, I have 2 questions.

 

1. How can I group data by production date according to length 1,2,3? 

2. How can I make tolerance zone using color? (In above chart, I would like to make green zone)

 

I will wait for your help.

Thank you!

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How can I classify data when I make box-plot?

I think your problem is the way you have the data table structured. 

 

Stack the length and width columns so that all of the length values are in one column and all of the width values are in another column. The stack command will actually create a column called "Label" (the default name) that identifies if it is length 1, 2, or 3. Also, change the Date column to be a Nominal modeling type.

 

Then in graph builder drag the Length (or Width) column to the Y-axis. Drag the "Label" column to the x-axis. Now drag the date column so that it is INSIDE of the x-axis to create the subgrouping.

 

I assume that you know how to do the rest, but if more help is needed, please let us know.

Dan Obermiller

View solution in original post

1 REPLY 1

Re: How can I classify data when I make box-plot?

I think your problem is the way you have the data table structured. 

 

Stack the length and width columns so that all of the length values are in one column and all of the width values are in another column. The stack command will actually create a column called "Label" (the default name) that identifies if it is length 1, 2, or 3. Also, change the Date column to be a Nominal modeling type.

 

Then in graph builder drag the Length (or Width) column to the Y-axis. Drag the "Label" column to the x-axis. Now drag the date column so that it is INSIDE of the x-axis to create the subgrouping.

 

I assume that you know how to do the rest, but if more help is needed, please let us know.

Dan Obermiller