nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

amiro

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!

Screenshot_jan2025.jpg

Accepted answers

Jonas_Rinne

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

jthi

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

Ben_BarrIngh

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;);

All comments

Jonas_Rinne

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

mmarchandFSLR

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

jthi

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
);

Jonas_Rinne

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.

Ben_BarrIngh

Hi @amiro ,

//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;);

amiro

Thanks a lot!

amiro

Thank you!

amiro

Great! Thank you very much Ben!