You can apply a filter to your aggregation to filter rows that you have already transformed with the aggregation.

To apply an aggregate filter:

  1. Select Transformation views from the left-side panel.
  2. Select a dataset from the list.
  3. Select Aggregate filter .
    The filter properties display in the Aggregate filter panel on the right.
  4. Select from the Show items that match dropdown if you want to show items that match All or Any of the filters you set.
  5. Select the aggregate column you want to filter from the Select column dropdown.
  6. Select the condition of the filter from the Select condition dropdown.
  7. If a field displays after you select a condition, enter the condition value.
  8. Select Save and then select Apply.