Show Menu
TOPICS×

Filter dimensions overview

You can filter on dimensions that you add to the Row Labels grid. Filters narrow the data returned by requests and can be applied from the Pivot or Custom Layouts. When you configure dimension filtering from the Pivot Layout, you can additionally specify the number of entries from cell.
The selected filter form is populated based on the element & metric that is selected in the report builder request.

Define filter - values and special characters

Information about filters in the Most Popular Filter > Define Filter panel.
The following tables provide examples and information about filters:
Filter Description Example Filter Match Results
Contains all terms
Contains every space-delimited value in any order.
a b c
Matches a b c and b a c , and so on.
Contains any term
Contains at least one of the filters (space-delimited).
A B C
Matches A1 , B2 , C3 , but not D4 .
Contains the phrase
Contains the search filter and possibly other terms.
abc
Matches abc and abc def .
Does not contain any term
Returns everything unless it contains a value you enter.
a b c
Matches d e f but not c d e f .
Does not contain the phrase
Returns everything that does not contain your phrase.
abc
Excludes abc , abc def and matches def
Equals
Returns an exact match.
abc
abc is returned, and nothing else.
Does not equal
Returns anything that does not exactly match your entry.
a
Does not match a .
Matches a b c .
Matches abc .
Starts with
Returns results that start with a specific value.
abc
Matches abcd but not 1abc
Ends with
Returns results that end with the specific value.
xyz
Matches wxyz but not wxyz0
Advanced (special characters)
Lets you regex characters:
"", ^, -, *, $, |
"^Home*Page$" | sports
This defines a filter that starts with Home , and then looks for zero or more characters, and then ends with Page .
Also, any page with sports in it.
A few example matches:
  • HomePage
  • Home and (other characters) Page
  • Home sports
  • sports Page
  • sports
  • xyz sports abc
Special Characters Purpose Notes
" " Equals
Not escaped unless it is not paired with another quote. For example, 17" Display is not a phrase.
* Wildcard
Same as the asterisk used in a regular expression.
^ Starts with
$ Ends with
- Not
| Or
Supported only in the Advanced (special characters) filter.