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

Question

Hi guys.

I would like to make box chart like below picture.

Raw data are length and width data by production date

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!

Dan_Obermiller · Accepted Answer

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.