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