Notification

This Help Center is moving to Cloud. Learn more about the migration.

Configure filter conditions

Filters conditions tell Looker Studio which records to include in or exclude from your report.

Include versus exclude filters

Include filters retrieve only the records that match the conditions, while exclude filters retrieve only the records that DON'T match the conditions.

Filter clauses

Conditions consist of one or more clauses.

A simple filter has just one clause that consists of a dimension or measure, a condition, and a value. For example, in the filter clause Country Equal to (=) FranceCountry is the dimension, Equal to (=) is the condition, and France is the value.  

Multiple clauses can be joined with an OR operator (true if any conditions are met), an AND operator (true if all conditions are met), or both. For example:

Country Equal to (=) France OR
Country Equal to (=) Germany
AND
User Type Equal to (=) New user
AND
Sessions Greater Than 100

A filter clause that uses an OR operator can contain dimensions or metrics, but not both.

Conditions

Conditions compare the fields in the filter against values that you provide. The available conditions depend on whether you are filtering a text, number, date, or logical field.

Text conditions
Conditions Description
Equal to (=) The comparison value exactly matches the dimension value.

Example: The comparison value "chrome" exactly matches "chrome" but not "Chrome" or "chromebook".

Contains The comparison value is contained within the dimension value.

Example: The comparison value "chrome" is contained within "chrome" and "chromebook" but not "Chrome".

Starts with The dimension value starts with the comparison value.

Example: The comparison value "Chrome" starts "Chrome" and "Chromebook" but not "Google Chrome".

Regexp Contains The dimension value contains the regular expression.

Example:

(?i)C[a-z]* matches "chrome", "Chrome", "Chromebook", and "Google Chrome".

Regexp Contains searches for the regular expression anywhere in the data.

The (?i) flag makes the regular expression case-insensitive.

Regexp Match The dimension value matches the regular expression.

Example:

C[a-z]* matches "Chromebook" and "Chrome", but not "Google Chrome".

Regexp Match is an exact match expression: the data must begin with "C".

In One or more of the comparison values exactly matches the dimension value. Works just like Equals but for a comma-separated list of values.

Example:

In Chrome,Windows,MacOS matches if any of those are in the dimension.

If your values contain commas or backslashes as part of the data to match, use a backslash to escape them.

Example:

If you want to match "ab,cd" and "50\50", precede the comma and backslash with \:

In "ab\,cd, 50\\50"

Is Null Matches if the dimension value is null.

Text comparisons are case-sensitive. For case-insensitive matching, use Regex.

Regular expressions in Looker Studio use Google RE2 regex syntax.

Numeric and date conditions

Condition Description
Equal to (=) The dimension or metric value is equal to the comparison value.
Less than (<) The dimension or metric value is less than the comparison value.
Greater than (>) The dimension or metric value is greater than the comparison value.
Greater than or equal to (>=) The dimension or metric value is greater than or equal to the comparison value.
Less than or equal to (<=) The dimension or metric value is less than or equal to the comparison value.
Between (>=&&<=) The dimension or metric value is within the specified range. The range includes the numbers or dates specified.
Is Null The dimension or metric value is null.

Boolean conditions

Condition Description
True The dimension value evaluates to "true".
False The dimension value evaluates to "false".
Is Null The dimension or metric value is null.

Values

When defining filters on charts, pages, or reports that use Equal to (=) or In conditions, report editors can select from a list of possible filter values that are provided from the underlying data. To see filter value suggestions, enable Show suggested values while typing in the filter editor. Filter suggestions are supported for all data connectors.

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
587968435441540276
true
Search Help Center
true
true
true
true
true
102097
false
false