Add a Filter data by values transformation

The filter data by values transformation allows you to include or exclude rows based on specific values in one or more fields. It’s similar to the SQL WHERE clause. Use this transformation to selectively filter data points directly within your visualization. This transformation is very useful if your data source does not natively filter by values. You might also use this to narrow values to display if you are using a shared query.

To use the filter data by values transformation, complete the following steps:

1. Open your dashboard in edit mode.

2. Click Transformations tab and click + Add transformation button.

3. Select or search for Filter data by values.

4. On the Filter type, select if you want an include or exclude filter.

5. On the Condition, select if you want the filter type to match all conditions or just match any.

6. Use the following table as a guideline for when to use the different conditions.

   Expand table

   Conditions	When to use
   Regex	When you want to match a regex expression.
   Is null	When you want to match if the value is null.
   Is not null	When you want to match if the value is not null.
   Is equal	When you want to match if the value is equal to the specified value.
   Is not equal	When you want to match if the value is not equal to the specified value.
   Contains substring (for string fields)	When you want to match if the value contains the specified substring.
   Does not contain substring (for string fields)	When you want to match if the value does not contain the specified substring.
   Is greater (for numeric fields)	When you want to match if the value is greater than the specified value.
   Is greater or equal (for numeric fields)	When you want to match if the value is greater or equal than the specified value.
   Is lower (for numeric fields)	When you want to match if the value is lower than the specified value.
   Is lower or equal (for numeric fields)	When you want to match if the value is lower or equal than the specified value.
   Is between (for numeric fields)	When you want to match when field value is in between given values.

7. The transformation should be applied automatically. If not, click Refresh to verify the visualization looks as intended.

   The following image shows a filter data by values transformation that excludes browsers with less than or equal to 5% market share.

8. Save your dashboard.