Data Filter preferences customize settings for data filters.
Figure 14.9 Data Filter Preferences
Preference | Description |
---|---|
Modes | Specifies the filtering mode. Select Shows the selected rows in the data table in a highlighted state. This option is selected by default. Show Shows the unselected rows with the Hide icon. This option is deselected by default. Include Shows the unselected rows with the Exclude icon. This option is deselected by default. |
Options | Specifies options for the data filter. Auto clear 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. This option is deselected by default. Grouped by AND Enables you to control the AND and OR behavior of multiple groups of column filters. This option is deselected by default. Conditional Limits the categories displayed for the selected filter column. This option is deselected by default. Use Floating Window Keeps the Data Filter window on top of its associated data table. This option is selected by default. Select Missing Highlights missing values in the data table. This option is deselected by default. |
Display | Specifies display options for categorical columns. Check Box Display Shows a check box next to each level. This option is deselected by default. Show Histograms and Bars Shows the histogram and bars in the data filter. This option is selected by default. |