Filters are used to restrict or limit data in a report, building the report to show only the information you want to view.
Within each dimension, you can have non-numeric and numeric filters.
Non-numeric filters include the following types:
- Does Not Contain
- All relative time filters such as 'Current Year' or '3 Years Ago'.
Numeric filters include the following types:
- Top N
- Greater Than/Less Than filters
Each dimension is filtered independently and the results are logically AND'd together.
Non-numeric filters are always applied before numeric filters and the two groups of filters are AND'd together. Within non-numeric filters, the following operators are OR'd together: Include, Contains, Before, After, Between and relative time filters. These filters are then AND'd together with the Exclude and Does Not Contain operators.
Here's a visual representation:
Include OR Contain OR Before OR After OR Between OR Any Time Filter
) AND (
Exclude AND Not Contain
The above filters are then AND'd with any numeric filters:
AND (Top 10 AND Greater Than)
Within a Contain or Not Contain operator, the individual expressions are OR'd together.