topic Re: Short cut for creating table with out of limits points from a control chart in Discussions

Short cut for creating table with out of limits points from a control chart

amiro — Fri, 07 Feb 2025 11:31:17 GMT

Hi "@Ben_Barringh" or anyone who could help me : )

Is there an easy way for creating a table with the points that are found out of the limits in a control chart?

I mean, once I have the points identified and selected in the general table (as shown in the picture): Is there a shortcut to have all the rows selected together in a new column or table?

Thanks a lot!

Re: Short cut for creating table with out of limits points from a control chart

Jonas_Rinne — Fri, 07 Feb 2025 12:02:57 GMT

Hi,

You can build a subset by simply right clicking in the lower left hand corner of your table after selecting the points:

To get an indicator column you can use rows -> row selection -> make indicator column to flag the selected rows in a new column.

Hope this helps,

Jonas

Re: Short cut for creating table with out of limits points from a control chart

mmarchandFSLR — Fri, 07 Feb 2025 13:00:59 GMT

I'm going to do @hogi's job here. There's a wishlist item for this very thing. You should go give it the thumbs up.

Wishlist: Is In Spec

Re: Short cut for creating table with out of limits points from a control chart

jthi — Fri, 07 Feb 2025 14:05:39 GMT

Name Selection In Column is one option

You can then create script / shortcut / toolbar based on that. You can also access that directly from Control Chart

The script could be something like this

Current Data Table() << Name Selection in Column(Column Name("OOC"),
	Selected(1),
	Unselected(0),
	Label Column
);

Edit: From here you can find information about how to build toolbar and add shortcuts Using JMP > Customize Menus and Toolbars and especially Using JMP > Customize Menus and Toolbars > Customize JMP Toolbars and Menus on Windows > Create Menu Items and Toolbar Buttons

Re: Short cut for creating table with out of limits points from a control chart

Jonas_Rinne — Fri, 07 Feb 2025 13:09:18 GMT

There is also the option to use the "save summaries" table under the red triangle of your control chart.

This table contains the values of your variable, the moving range and the control limits of the moving range. With rows -> row selection -> select where you can select where the moving range falls outside of the control limits. The row numbers in the summary table matching the rows in your original table (unless you have build some customized control charts). So this selection can be used for an automated approach with JSL in case you do not want to do the selection by hand.

Re: Short cut for creating table with out of limits points from a control chart

Ben_BarrIngh — Tue, 11 Feb 2025 11:22:58 GMT

Hi @amiro ,

I've put together a script that you can run after you perform the 'save summaries' as @Jonas_Rinne has suggested, the user points JMP to the original data table and the summary data table and then a 'Data View' of those rows appears in the original table (as I thought it may be useful to keep the links 'live' rather than sub-setting). You could easily pair this with the workflow builder for the initial creation of the control charts and the summary data tables.

//Get list of open data tables
DTlist=get data table list();

//Create User Selection Window to pick out the 'before' and 'after' tables that will be used to filter out the failed runs
New Window( "Test",
Text Box ("Use this script after running the 'Save Summaries' option in Control Chart Builder with Test 1 active"),
	V List Box(
		"Test",
		OGOB = Outline Box(
			"Select your original data table",
			OGList = List Box( dtlist )
		),
		SummOB =
		Outline Box( "Select your summary table" ,
			SummList = List Box(dtlist)
		),
	Button Box("OK", (dtorigname=oglist<<get selected; dtsummname=summlist<<get selected; run_expr;));

));

//Find the rows where Test Failures = 1 and filter out with data view in the original table
Run_expr=expr(
//Save Summaries
dtorig=Data Table(dtorigname[1]);
dtsumm=Data Table(dtsummname[1]);
//Get the failed rows where the test failure has occurred
failedrows=dtsumm<<Get Rows where (:test failures == "1");

//Go back to the original data table and select the same rows and provide a data view
listdt=dtorig<<select rows(failedrows)<<data view;);

Re: Short cut for creating table with out of limits points from a control chart

amiro — Thu, 13 Feb 2025 08:21:20 GMT

Thanks a lot!

Re: Short cut for creating table with out of limits points from a control chart

amiro — Thu, 13 Feb 2025 08:21:36 GMT

Thank you!

Re: Short cut for creating table with out of limits points from a control chart

amiro — Thu, 13 Feb 2025 08:21:57 GMT

Great! Thank you very much Ben!