Configure filter conditions

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

Include vs 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. For example, Country Equals "France".

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

Country Equals "France" OR
Country Equals "Germany"
AND
User Type Equals "New user"
AND
Sessions Greater Than 100

An OR clause can contain dimensions or metrics, but not both.

Operators

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

Text operators

Operator	Description
Equals	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 looks 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", "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 operators

Operator	Description
Equals ("=")	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 operators

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

Was this helpful?

How can we improve it?