For Control Chart Builder allow x-axis or Subgroup zone if it is a timestamp column to let user switch between scaled time or evenly spaced points like standard SPC charts

[Vball247]

What inspired this wish list request? Control Chart Builder, even as of JMP18, will by default order the Subgroup alphanumerically if character. Sometimes the Subgroup item like "LotID" is not in alphanumeric order according to the actual timestamp. If timestamp is used instead as numeric, the order is correct, but it is scaling timestamp, and sometimes points are on top of each other, instead of in sequence as a typical SPC chart from the past is shown. If you change timestamp to character, the AM/PM part of the time stamp gets out of order if using this date/time format.

For example, in this random data, the LotID is in alphanumeric order. But the actual first lot to run is 9013108 on 01/30. Trying to make the CCB with LotID is not the right order, and using the timestamp column makes the data clump up sometimes.

LotID	Time
9013101	01/31/2021 2:50:16 AM
9013102	01/31/2021 2:18:22 AM
9013103	01/31/2021 2:35:41 PM
9013106	01/31/2021 12:45:53 AM
9013107	01/31/2021 6:34:31 AM
9013108	01/30/2021 3:59:54 PM
9013109	01/31/2021 5:49:05 AM
9020104	02/01/2021 3:03:20 AM
9020106	01/31/2021 11:30:52 PM

What is the improvement you would like to see? Allow user for a timestamp column to select either the x-axis scaled (to look for gaps in time) or to plot sequentially. This is because the traditional SPC chart is plotted in time order, but each point is added sequentially, and not scaled to time. This prevents pile up of data points for when sampling was high and it is hard to see individual points, and wide gaps when sampling was low. But sometimes a user wants to see those gaps to see how the material was sampled. 

Why is this idea important?  Since Control Chart Builder is a platform just for SPC charts, it should allow easy use of the Subgroup axis for time, lot numbers, etc. This also prevents having to use the "Edit Value Order" and use "Row Order Levels", to plot the timestamp sequentially. See Case Number TS-00206416 for details. 

[PatrickGiuliano]

Hello @Vball247 Thanks for your Wishlist item! It turns out that JMP 19 (to be released later this year) will have a red triangle menu option called "Sort by Subgroup" which should address your request (without needing to change the data type or modeling type of the Timestamp column, and without the need to set Value Order as a column Property on a Nominal or Ordinal modeling type for the LotID column).  I'm demonstrating with the EA (early adopter) 8 release version, so this will function the same in the new commercial release once it's ready:

Once you're happy with the chronological order by lot (ordered in time), you can always "turn off" the display on the Time Column, by going into the X Axis Settings and unchecking the "Show Tick Labels" option.  

 

I believe this will get you what you want but feel free to test this out once you're able to get your hands on a copy of JMP 19 and for any questions or concerns please direct them to support@jmp.com.  

Cheers,

Patrick Giuliano

JMP Technical Support

[mia_stephens]

Thank you for submitting this request @Vball247 , and for your detailed response about functionality coming in the next release @PatrickGiuliano. Changing the status to yes, stay tuned, but please give it a try in an Early Adopter release if you have an opportunity. Prior to the release of JMP 19, please send feedback to jmpbeta@jmp.com.