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. For example, using Big Class.jmp, suppose that you have the columns sex (nominal) and age (ordinal) in your Data Filter. If you have males (M) selected for sex, and you click on an age group, say age 12, your selection of males will be automatically cleared. This means that selecting age 12 is not conditional on selecting males. Conversely, if you turn off Auto clear, you can then select both males and age 12 at the same time. Auto clear is on by default.
Enables you to control the AND and OR behavior of multiple groups of column filters. See Grouped by AND in Data Filters.
Sequentially highlights the values of a single variable in the data table. See Animation in Data Filters.
The following example illustrates how the Conditional option helps show the subcategories clearly, without the extra categories that do not belong.
1.
|
2.
|
Select Rows > Data Filter.
|
3.
|
4.
|
Select Conditional from the Data Filter red triangle menu.
|
5.
|
Select MW in the Region list.
|
6.
|
Select OH from the State list.
|
The cities that are in Ohio and in the Midwest region are selected in the data table. In the Data Filter window, only Midwestern states appear in the State list, and only cities in Ohio appear in the cities list. See Figure 8.11.
Figure 8.11 Using the Conditional Option
The bracketed number in front of the column name indicates the order in which the column values were selected. In Figure 8.11, Region was selected first, so it has a [1] in front of the column name. State was selected second, so it has a [2] in front of the column name.
1.
|
2.
|
Select Rows > Data Filter.
|
3.
|
Select Grouped By AND from the Data Filter red triangle menu.
|
4.
|
5.
|
sex is added to the same group as age.
6.
|
age and sex are in the same group. In the data table, rows that meet either the age OR sex conditions are selected. That is, all 14-year-olds and all males are selected in the data table.
7.
|
8.
|
Figure 8.12 Data Filter with Grouped by AND Condition