Working with Advanced Filters :: SAS® Visual Analytics 7.4: User's Guide

About Advanced Filters

For all visualization types, you can create advanced filters to subset your data by using the Filters tab.

Advanced filters enable you to create filters that use more than one data item.

Your advanced filters can be either local filters that apply only to the current visualization, or global filters that apply to all of the visualizations that use the selected data source.

The total percentage of values that are selected by your filters is displayed at the bottom of the Filters tab. The tooltip for the percentage displays the exact number of data rows. The percentage is calculated after data source filters are applied.

Create an Advanced Filter

To create an advanced filter:

Click the drop-down list in the global filters area or in the local filters area of the Filters tab, and then select New Advanced Filter. The Edit Filter window appears.
Specify a Filter name. The filter name identifies the advanced filter on the Filters tab.
Build the expression for your filter by dragging and dropping data items, global parameters, conditions, and operators onto the expression.

For information about the conditions and operators that are available, see Conditions for Filters and Operators for Data Expressions .

You can also build your expression as text by using the Text tab. See Editing a Data Expression in Text Mode.
Click OK to apply the filter.

Edit an Advanced Filter

To edit an advanced filter:

Select the Filters tab.
Click the drop-down list for the filter that you want to edit, and then select Edit Filter. The Edit Filter window appears.
Edit the expression for the filter. For more information, see Editing a Filter Expression.