Combine and Group Filters

You can combine and group multiple inline filters to create complex filters without using SQL statements.

You group or combine filters to establish the precedence in which data in an analysis is filtered. When you add two or more inline filters to an analysis or named filters, by default, the inline filters are combined using the AND Boolean operator. The AND operator indicates that the criteria specified in all the inline filters must be met to determine the results when an analysis is run.

You use the OR Boolean operator to indicate that the criteria specified in at least one of the filters must be met to determine the results of the analysis. The OR operator helps you to create a group of multiple filters using alternate criteria.

1. Open for editing a named filter or an analysis that contains inline filters.
2. On the Filters pane of the Criteria tab, confirm that the analysis contains two or more inline filters. Alternatively, on the Saved Filter pane, confirm that the named filter contains two or more inline filters.
3. On the Saved Filter pane or in the Filters pane of the Criteria tab, notice how the inline filters are combined using AND or OR operators.
4. Click the word AND before an inline filter to change an AND operator to an OR operator. You can toggle between the AND and OR operator in this way.
5. Change the AND and OR operators for other inline filters to create the required filter combinations. Alternatively, create more inline filters and change the AND and OR operators.
6. Click Save Analysis or Save Filter to save the filter combinations.