- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Short cut for creating table with out of limits points from a control chart
Hi "@Ben_Barringh" or anyone who could help me : )
Thanks a lot!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Short cut for creating table with out of limits points from a control chart
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 Men...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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;);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Short cut for creating table with out of limits points from a control chart
Thanks a lot!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Short cut for creating table with out of limits points from a control chart
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 Men...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Short cut for creating table with out of limits points from a control chart
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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;);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Short cut for creating table with out of limits points from a control chart
Great! Thank you very much Ben!