DocumentationAnalyticsTools Guide

Filter dimensions overview

Last update: Thu Oct 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
  • Admin
IMPORTANT
A new and streamlined Report Builder was released on October 16, 2024. It is supported on Mac, Windows, and web browsers.
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.

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 section_15840216A4044C40974945FAA435AD93

Information about filters in the Most Popular Filter > Define Filter panel.

Screenshot showing the Define Filter dialogue with options to Filter by Application, User, and Project.

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 cand 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.
recommendation-more-help
a83f8947-1ec6-4156-b2fc-94b5551b3efc