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.
The following example illustrates how the Conditional option helps show the subcategories clearly, without the extra categories that do not belong.
1.
Select Help > Sample Data Library and open Cities.jmp.
2.
Select Rows > Data Filter.
3.
In the Data Filter window, select city, State, and Region, and then click Add.
4.
Select Conditional from the Data Filter red triangle menu.
5.
Select MW in the Region list.
6.
Select OH from the State list.
Using the Conditional Option
The bracketed number in front of the column name indicates the order in which the column values were selected. In Using the Conditional Option, 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.
You can reverse the AND and OR behavior by selecting Grouped by AND from the red triangle menu.
1.
Select Help > Sample Data Library and open Big Class.jmp.
2.
Select Rows > Data Filter.
3.
4.
Click AND and add the sex column.
5.
Hold down the Ctrl key, select 14 from the age filter, and select M from the sex filter.
6.
Click OR and add the weight column.
7.
Move the left weight slider to approximately 112.
14-year-old males or students who weigh greater than 112 are selected.
Data Filter with OR Condition
8.
Select Grouped by AND from the Data Filter red triangle menu.
14-year-olds or males and students who weigh greater than 112 are selected.
Data Filter with Grouped by AND Condition
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.
Animation Control Panel in the Data Filter
The square button () hides the Animation Control section on the Data Filter window. Select Animation from the menu on the Data Filter title bar again to see the Animation Control.
1.
Select Help > Sample Data Library and open Big Class.jmp.
2.
Select Rows > Data Filter.
3.
Select age, sex, and height and click Add.
7.
From the red triangle menu next to Data Filter, select Save Where Clause > To Script Window.
Select Where(
(:age == 12 | :age == 14) & :sex == "F" & (:height >= 56 & :height <= 60)
);

Help created on 9/19/2017