cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Due to the recently reported Microsoft outage, users may be temporarily unable to access My JMP or experience a delay receiving their verification codes. If you have previously installed JMP on your computer, this outage should not impact your ability to access the software. My JMP services will be restored as soon as Microsoft resolves this issue.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
markschahl
Level VI

How to filter to show last n items/values?

Let's use the Semiconductor Capability sample data table for context.

Column lot_id has 13 levels.
Say I want to IMR control chart the last lot only or only the last 5 lots in the data table. Is there an elegant way to do this kind of last n filtering other than manually scrolling through the list of lot_id and manually picking the last 5 lots?

Alternatively, I have years of process sensor data in my data table. I only want to plot the last six months worth.

11 REPLIES 11

Re: How to filter to show last n items/values?

Good news! Starting in JMP 19.0, there is a new feature in Control Chart Builder called, "Set Last N Subgroups", which will adjust the X-axis to always show the most recent N subgroups, regardless of any updates to the data or chart. 

markschahl
Level VI

Re: How to filter to show last n items/values?

Thanks for the confirmation, Annie!

I attended your talk at Discovery24, and I thought you mentioned this as an improvement. Looking forward to it.

Recommended Articles