Add a Filter data by values transformation

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.

   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.