Using JMP > JMP Reports > The Data Filter > Red Triangle Options for Variables in Data Filters
Publication date: 04/12/2021

Red Triangle Options for Variables in Data Filters

After you add a column to the data filter, a red triangle menu appears. 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

Shows a submenu of modeling types for the column filter. By default, the column filter type is set to the column’s modeling type. You can change the filter type by selecting a different modeling type in the submenu.

Options for Continuous Variables

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. The updated range is highlighted in blue.

The following options are available for continuous variables only:

Select Missing

Selects rows that contain missing values.

Include Minimum Value

Includes or excludes the minimum value in the selected range. When the minimum value is excluded, the solid vertical line in the histogram becomes a dashed vertical line.

Include Maximum Value

Includes or excludes the maximum value in the selected range. When the maximum value is excluded, the solid vertical line in the histogram becomes a dashed vertical line.

Set Number of Bins

Sets the number of bins for the histogram.

Zoom to Selection

Shows only the selected range in the histogram. The menu item changes to Reset Zoom after you select it. Reset Zoom resets the display.

Options for Nominal or Ordinal Variables

For nominal and ordinal variables, values appear in blocks, in a list, or in a menu. If the variable contains only a small number of categories, the values appear in blocks. If the variable contains a large number of categories, the values appear in a list or in a menu. However, you can change these default settings.

The following options are available for nominal or ordinal variables only:

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. To make this the default setting, select the Check Box Display option in File > Preferences > Data Filter.

Radio Box Display

Adds a radio button 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 Enter to perform the search.

Options for Variables with the Multiple Response Modeling Type or Column Property

The following options are available for variables with the Multiple Response modeling type or column property:

Display Options

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

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. To make this the default setting, select the Check Box Display option in File > Preferences > Data Filter.

Radio Box Display

Adds a radio button next to each value.

Match None

Selects only rows containing values that do not match any of the selections

Match Any

Selects all rows that contain values that match any of the selected values. By default, this option is selected.

Match All

Selects only rows with values that include all of the selected values.

Match Exactly

Selects only those rows with values that exactly match the checked values.

Match Only

Selects only those rows with contents exactly matching the checked values.

Match At Least

Selects at least n of the selected values.

Match At Most

Selects a maximum of n of the selected values.

Match Between

Selects between n and m of the selected values.

Find

Provides a text box where you can enter a search string for the selected column. Press Enter to perform the search.

Note: For more information about the Multiple Response property, see the Multiple Response.

Options for Unstructured Text

The following options are available for variables with the Unstructured Text modeling type:

Case Sensitive

If this box is checked, the filter based on the word or phrase typed in the filter text edit box is case sensitive.

Regular Expression

Assumes the string typed into the filter text edit box is a regular expression instead of a literal string.

Display Options

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

List Display

Shows each word or phrase as a member of a list, followed by its frequency.

Single Category Display

Shows each word or phrase, followed by its frequency, in a menu.

Check Box Display

Adds a check box next to each word or phrase. To make this the default setting, select the Check Box Display option in File > Preferences > Data Filter.

Radio Box Display

Adds a radio button next to each word or phrase.

Add Missing

Adds a filter for entries that do not contain any text.

Clear Filter Texts List

Removes any words or phrases that had been added to the filter text list.

Show Filter Text Edit Box

Shows or hides the filter text edit box.

Order by Count

Orders the words or phrases in decreasing sort order by count.

Match None

Selects only rows containing text that does not match any of the selected words or phrases.

Match Any

Selects all rows that contain text that matches any of the selected words or phrases. By default, this option is selected.

Match All

Selects only rows with text that includes all of the selected words or phrases.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).