Data Filter

The Data Filter is a JMP feature that gives you a variety of ways to select, hide, or exclude subsets of data from plots and analyses. JMP's Data Filter is surfaced at different levels in JMP Clinical: at the Review level (Review Subject Filter, shown below), at the Report level (Report Filter) and within reports (Local Data Filter or Section Filter).

Refer to The JMP Data Filter for more information.

Main Controls

The main controls in the Data Filter can include the following:

Clear: Clears all selections that you have made on variables in the Data Filter window.

Select: Click the check box to show the selected rows in the data table in a highlighted state.

Reset: Resets the data filter to the default settings.

AND: Opens the Add to Selected Group list. The and operator restricts the selection. You can add variables to the filter report at any time.

Note: There are several additional options when filtering. These options are available from the red triangle menu for the Data Filter.

Changing the Row State in the Data Table After Making Data Filter Selections

If you modify a row state that you have set in the Data Filter and subsequently alter row states in the data table, or select points in a graph or plot, the selections in the Data Filter might not match the selections in the data table. The Data Filter contains a warning message that says: Your selection was changed in another window. The Reset Selection button appears. Clicking Reset Selection changes the data table selections back to reflect the selections in the Data Filter.

Red Triangle Options for the Data Filter

The red triangle menu next to Data Filter contains the following options:

Auto clear:

If you have more than one nominal or ordinal column selected in the Data Filter, this option clears any other selections before making a new selection.

Conditional:

Limits the categories displayed for the unselected filter column. For filter columns with hierarchy, you can use the Conditional option to filter what appears in the column lists.

Grouped by AND

Enables you to control the AND and OR behavior of multiple groups of column filters.

Show Histograms and Bars

Shows or hides the histogram and bars in the data filter.

Show Counts

Shows or hides the counts in the categorical column data filters.

Use Floating Window:

Keeps the Data Filter window on top of its associated data table. If you do not want the Data Filter window to remain on top, deselect this option.

Start Over

Closes the current Data Filter session and shows the original Data Filter window.

Show Controls

Shows or hides all buttons and check boxes in the Data Filter window except Clear and Inverse.

Show Modes

Shows or hides the filtering mode check boxes in the Data Filter window.

Animation:

The animation feature sequentially highlights the values of a single variable. The variable’s values highlight in the data table. However, patterns are more interesting if you first create a plot and then animate a variable using the Data Filter to see how it behaves on the plot.

To use the animation feature, from the red triangle menu next to Data Filter, select Animation. Then select the variable that you want to animate. The highlighted frame around the variable indicates which variable is selected for animation

The Animation Controls panel (shown above) is surfaced when you select Animation. It contains the following controls:

The middle button starts and stops the animation. After you start the animation cycles, the button changes to a stop button (). By default the animation begins with the first value of the topmost variable.

The backward arrow moves the animation backward one cycle. Click more than once to go backward more than one cycle.

The forward arrow moves the animation forward one cycle. Click more than once to go forward more than one cycle.

The square button hides the Animation Controls panel on the Data Filter Window. Select Animation from the menu on the Data Filter title bar again to see the Animation Controls.

Use the slider to adjust the speed of the animation (slower to faster).

The drop-down menu contains the following options:

Forward: Highlights values from first to last.

Backward: Highlights values from last to first.

Bounce: Highlights forward and then backward repeatedly.

Show Subset: Creates a new data table that contains only the following:

The rows identified by the Data Filter.

The columns selected in the active data table. If no columns are selected, then all columns are included.

Save WHERE Clause:

Once you have filtered variable values in the Data Filter, that information can be expressed as a JMP WHERE clause that is to identify specific rows of data for reporting or analysis. The Data Filter builds a WHERE clause based on the value selections that you make.

The options in the Save WHERE Clause menu include the following:

to Clipboard: Creates a WHERE clause from the filter criteria and puts it on the clipboard.

to Row State Column: Creates a row state column in the data table that has a formula equivalent to the filter criteria.

to Data Table: Creates a WHERE clause from the filter criteria and saves it as a JSL command with the current data table in a table property called Filter.

to Script Window: Creates a WHERE clause from the filter criteria and appends it to the current script text window, or creates a new script if one does not exist already.

to Journal: Creates the WHERE clause from the filter criteria and appends it to the current journal, or creates a new journal if one does not already exist.

Save Script: Provides options for saving scripts. Red Triangle Options for Variables

Some of the red triangle options for a variable can vary, depending on the type of variable.

Options for All Types of Variables

The red triangle menu next to any type of variable contains the following generic options:

Clear Selection

Clears any selection in effect for that variable only.

Invert Selection

Deselects any selected values, and selects all values previously not selected, for that variable only.

Modeling Type

Enables you to specify how you want to model the data for that variable. Options can include the following:

Continuous: For continuous variables, values appear in a histogram with vertical lines at the minimum and maximum values. You can adjust the selected range by clicking on the vertical lines and dragging.

Nominal/Ordinal: For nominal and ordinal variables, values appear in blocks, in a list, or in a menu.

Multiple Response lists different options for modeling variables with multiple responses.

Unstructured Text ists different options for modeling variables with text.

Display Options

Changes the appearance of the display. Options can include the following:

Blocks Display shows each level as a block.

List Display shows each level as a member of a list, followed by its frequency.

Single Category Display shows each level, followed by its frequency, in a menu.

Check Box Display adds a check box next to each value.

Order by Count

Orders the values in decreasing sort order by count.

Find

Provides a text box where you can enter a search string for the selected column. Press the Enter key to perform the search. Once Find is selected, the following Find options appear in the red triangle menu:

Clear Find clears the results of the Find operation and returns the window to its original state.

Match Case uses the case of the search string to return the correct results.

Contains searches the data for values that includes the search string.

Does not contain searches the data for values that do not include the search string.

Starts with searches the data for values that start with the search string.

Ends with searches the data for values that end with the search string.