cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

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

amiro
Level I
 

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!

3 ACCEPTED SOLUTIONS

Accepted Solutions

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

Hi,

 

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

Jonas_Rinne_0-1738929626900.png

 

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

View solution in original post

jthi
Super User

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

Name Selection In Column is one option

jthi_0-1738933420743.png

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

jthi_1-1738933499105.png

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 Men... 

-Jarmo

View solution in original post

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

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 models are wrong, but some are useful”

View solution in original post

8 REPLIES 8

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

Hi,

 

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

Jonas_Rinne_0-1738929626900.png

 

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

amiro
Level I

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

Thanks a lot!

mmarchandFSLR
Level IV

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

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

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.

 

 

jthi
Super User

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

Name Selection In Column is one option

jthi_0-1738933420743.png

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

jthi_1-1738933499105.png

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 Men... 

-Jarmo
amiro
Level I

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

Thank you!

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

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 models are wrong, but some are useful”
amiro
Level I

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

Great! Thank you very much Ben!