These filter types are the same on both report and dashboard filters.

The options available are: Equals, Does not equal, Contains, Does not contain, Matches regex and Exclude empty values. We will discuss how each of these filter types work.

For example, suppose you have a list of colours; blue, green, red, violet, orange and yellow.

Equals

This filter type will provide a dropdown list of the values available.
Therefore, a filter stating: Colours equal "red", "green" will retrieve only the values red and green.

Does not equal

This filter type will provide a dropdown list and retrieve all values except for those selected.
Therefore, a filter stating: Colours does not equal "red", "green" will retrieve the values blue, violet, orange and yellow.

Contains

This filter type will provide a text-box to insert the values which the dimension must contain.
Therefore, a filter stating: Colours contains "L" will retrieve the values blue, violet and yellow.

Does not contain

This filter type will provide a text-box to insert the values which the dimension must not contain.
Therefore, a filter stating: Colours does not contain "RE" will retrieve the values blue, violet, orange and yellow.

Matches regex

This filter type will provide a text-box to insert the multiple values that the dimension must contain. Each of these values can be seperated with a pipe delimiter "|".
Therefore, a filter stating: Colours matches regex "or|let|re" will retrieve the values orange, violet, red and green.

This is because orange contains "or", violet contains "let" and red and green contain "re".

Exclude empty values

This will remove any rows which contain empty values - cleaning up your reports.

Did this answer your question?