cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

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