Purpose
The AddIn provides a collection of useful shortcuts for exploratory data analysis and manipulation.
How to Use
The toolbar may not be displayed by default. To display the toolbar, select View > Toolbars > QuickSelect.
Overview:
Short description of the Shortcuts:
1. Clear Hide & Exclude. Reset the hide/excluded state of all rows.
2. Clear selection clears the row selection
3. Text To Columns ... (from Cols/Utilities) *)
4. add dummy rows
workaround for Graph-Builder-Combine-Smoother-and-Line
select as many grouping columns as you want - JMP will add a dummy row (with missing value) for each combination
in the plot, select Missing Value: no connection
5 - 7: Three shortcuts along the idea: Save the current selection as a column:
5. Label Selected Rows. Similar to Name Selection in Column ...
The differences:
- It uses a column with data type Multiple Response, new information is appended, no pre-existing value is overwritten. This allows the user to collect information in an iterative way.
- predefined tags (which can be edited by the user via settings)
6. Add Selected Column (dynamic version). Generates a column with formula selected()to dynamically label selected/non-selected rows as 1/0. The column can be used in GraphBuilder plots as Overlay or Color to dynamically split the evaluation between the selected and non-selected subset (like it is explained in several webinars and Community posts).
7. Add Selected Column (static version). It just saves the current selection as 0/1.
8. new column: rows with neighbor
adds a new column with a vector of all rows which are "neighbors" of the specific row
a) specify the coordinates
b) optional: specify the grouping, e.g. lot & wafer
c) which kind of neighbors?
9. open the current selection as a linked subset
- extremely useful for on-the-fly data curation and exploratory data analysis
10. Invert. Invert the current row selection. "select all rows" (if no row is selected) *)
11. Current Selection -> Hide&Exclude. Mark the selected rows as hide&excluded *)
*) Thanks to a wonderful tip by @Jeff_Perkinson , the 3 Shortcut functions are now recorded by the advanced Log:
System Configuration
Add-in developed and tested using the following system configuration:
Windows
JMP 16 - 19
