1.
|
Tip: In addition to the main Data Filter, you can also launch a local Data Filter within a platform report. Click the Local Data Filter icon from the Report toolbar, or select Script > Local Data Filter from the red triangle menu in a report.
•
|
To restore your current row states when the Data Filter window is closed, select the Save and restore current row states option.
|
‒
|
Detach it temporarily by deselecting the Use Floating Window option from the Data Filter red triangle menu.
|
‒
|
Detach it persistently by selecting File > Preferences > Tables and deselecting the Use a Floating Window for Data Filters option.
|
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 > Tables.
There are three modes of filtering: Select, Show, and Include. You can set and clear these modes using the corresponding check boxes in the Data Filter.
You can turn off the automatic selection of this option using the Data Filter Select Check preference. See also Changing the Row State in the Data Table After Making Data Filter Selections.
You can turn on the automatic selection of this option using the Data Filter Show Check preference. For details about row states, see the Row State Columns in The Column Info Window.
You can turn on the automatic selection of this option using the Data Filter Include Check preference. For details about row states, see the Row State Columns in The Column Info Window.
There are two additional options when filtering: Auto clear and Conditional. These options are available from the red triangle menu for the Data Filter. For more information, see Red Triangle Options for the Data Filter.
Saves your current data filter criteria as a favorite. Once you have created a favorite, selecting it resets the current conditions to the criteria in the favorite. You can also remove the favorite. To retain favorites once the current session ends, save the data filter script by selecting one of the Script options from the Data Filter red triangle menu.
Note: Only the rows in the data table are inverted, not the selection in the Data Filter. To invert the selection in the Data Filter, from the column’s red triangle menu, select Invert Selection.
The AND button opens the Add Filter Columns list. The and operator restricts the selection. You can add variables to the filter process at any time.
The OR button opens the OR Add Filter Columns list. The or operator extends the selection. You can add variables to the filter process at any time.
If you modify a row state that you have set in the Data Filter and subsequently alter row states in the data table, or select points in a graph or plot, the selections in the Data Filter might not match the selections in the data table. The Data Filter contains a warning message that says: “Your selection was changed in another window”. The Reset Selection button appears. Clicking the Reset Selection button changes the data table selections back to reflect the selections in the Data Filter.
1.
|
Open the Big Class.jmp sample data table.
|
2.
|
Select Analyze > Distribution.
|
3.
|
4.
|
Click OK.
|
5.
|
Select Rows > Data Filter.
|
6.
|
Now the selection does not match the Data Filter selection. A warning message and a Reset selection button appear in the Data Filter window.
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.
For filter columns with hierarchy, you can use the Conditional option to filter what appears in the column lists. For example, you could filter by region so that only the states in the selected region appear in the list.
The following example illustrates how the Conditional option helps show the subcategories clearly, without the extra categories that do not belong.
1.
|
Open the Cities.jmp sample data table.
|
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 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.
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.
The Animation Control panel (Animation Control Panel in the Data Filter) contains the following controls:
•
|
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.
|
The options in the Save Where Clause menu include the following:
1.
|
Open the Big Class.jmp sample data table.
|
2.
|
Select Rows > Data Filter.
|
3.
|
7.
|
From the red triangle menu next to Data Filter, select Save Where Clause > to Script Window.
|
•
|
The Select Missing option highlights any missing values in the data table.
‒
|
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 Data Filter Check Box Display option in File > Preferences > Tables.
|
Provides a text box where you can enter a search string for the selected column. Press the Enter key to perform the search. Once Find is selected, the following Find options appear in the red triangle menu:
‒
|
Clear Find clears the results of the Find operation and returns the window to its original state.
|
‒
|
Match Case uses the case of the search string to return the correct results.
|
‒
|
Contains searches the data for values that includes the search string.
|
‒
|
Does not contain searches the data for values that do not include the search string.
|
‒
|
Starts with searches the data for values that start with the search string.
|
‒
|
Ends with searches the data for values that end with the search string.
|
Selects at least n of the selected values.
Selects a maximum of n of the selected values.