Using JMP > JMP Reports > The Data Filter > Red Triangle Options for Variables
Publication date: 08/13/2020

Red Triangle Options for Variables

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:

Delete

Removes the variable from the Data Filter control panel.

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.

Order by Count

Sorts the values in decreasing order by count.

Find

Opens a search box above the variable to enable you to search for values. The menu item changes to Clear Find after you select it.

Options for Continuous Variables

For continuous variables, values appear in a range with a slider that you can adjust in one of the following ways:

Click and drag the slider bar. You can drag from either end of the slider bar. The selected values appear above the slider bar.

Click anywhere in the empty (not selected) part of the slider to set the filter range at that point.

Click the number to enter the value that you want.

By default, the range of values includes an equal sign, which includes the endpoints. You can remove the equal sign by holding down the Shift key and clicking on the or the .

The Select Missing option highlights any missing values in the data table.

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 the Enter key to perform the search. See Search Filter Options.

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:

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 the Enter key to perform the search. See Search Filter Options.

Note: For more information about the Multiple Response property, see the Multiple Response in the The Column Info Window section.

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