cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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