Using JMP > JMP Reports > The Data Filter > Types of Filter Columns
Publication date: 03/23/2021

Types of Filter Columns

There are four types of filter columns:

Continuous columns

Filters numeric columns whose modeling type is set to continuous. A continuous filter column is represented by a histogram that spans the data range. You can adjust vertical lines on the histogram that represent the minimum and maximum filtered values. For options, see Options for All Types of Variables and Options for Continuous Variables.

Categorical columns

Filters nominal and ordinal columns. For each categorical column, the Data Filter generates a set of distinct categories. These categories can be displayed in different forms. For options, see Options for All Types of Variables and Options for Nominal or Ordinal Variables.

Note: For categorical columns with value labels, if you want to include responses that are not present in the data, select the Include Responses Not in Data option from File > Preferences > Platforms > Categorical.

Multiple Response columns

Filters character columns that have the Multiple Response column property or Multiple Response modeling type assigned. Each data cell of the column generally consists of multiple categories, separated by some common separator, like a comma. Since each data cell can contain more than one category, multiple response columns have a richer set of filtering options. For options, see Options for All Types of Variables and Options for Variables with the Multiple Response Modeling Type or Column Property.

Unstructured Text

Filters text columns whose modeling type is set to Unstructured Text. Type words or phrases into the filter text edit box to add them to the filter text list. You can then filter the rows based on these words and phrases. For options, see Options for All Types of Variables and Options for Unstructured Text.

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