530863_en-US

liliconcom

Filtered Data View

Purpose:

This Add-In creates a filterable view of your open data table so you can view only the rows and columns that meet the conditions you specify.

 

Video Example:

 

This video is currently being processed. Please try again in a few minutes.

(view in My Videos)

 

 

Instructions For Use:

• First download, then open the Add-In to install the new menu item "Filtered Data View" to your Add-Ins menu.
• With a data table already open, select the menu item Add-Ins > Filtered Data View. A new window will open with a linked subset of your original table, including two outline boxes on the right, Columns Filter and Data Filter.
  • The Columns Filter outline box allows you to select which columns you wish to see in your Filtered Data View.
  • The Data Filter outline box contains a JMP Data Filter where you can specify criteria your data must meet to be displayed in the Filtered Data View.
• To use the Columns Filter, select the columns you wish to see in the Filtered Data Table. Hit Clear, or deselect all columns to show all available columns in the Filtered Data Table.
• To use the Data Filter, select a column or columns to filter based on and click the plus sign. Then, in the resulting selection areas pick what criteria your data must meet in order to be included in the Filtered Data View. For more details on using the JMP Data filter, see this example video (Using the Local Data Filter ), or read about it in the JMP documentation.
• After making selections you can use JMP platforms as usual on your Filtered Data View and only the rows and columns you have selected will be available and used for analysis. 

 

Usage Notes:

• If you first select columns in your original table table, then select Add-Ins > Filtered Data View, the columns selected will be automatically added as filterable criteria in the Data Filter section. 
• The Filtered Data View table is a linked subset of your original table, so the selections you make in the Filtered Data View table will select the corresponding rows in your original table.
• The Filtered Data View table is locked by default. To unlock, select the Red Triangle next to the table name, and uncheck "Lock Data Table."
   
  Note that, as is the case with any linked subset in JMP, many changes you make in Filtered Data View table will not impact the original table, such as making new columns. Alterations to data in cells and column properties will impact your original table. Any adjustments you make to the columns or data filter will revert your table back to your original table.
• You can select Add-Ins > Filtered Data View with no table open and you will be prompted to pick a table. In this case, the original table is hidden from view by default, but can be shown by selecting the table under the menu item Window > Hidden.

 

This Add In creates a filterable data table so you can find rows that meet the conditions you specify.

Utilities