cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

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