(v24) Apply a Group Filter from a Metric

Apply a Group Filter from a Metric

This applies to: Visual Data Discovery

Suppose you want to find product sales greater than $200,000 for the last quarter within the greater Los Angeles area. You might create a group filter using the following steps. This example requires that you have already applied a row-level filter for the city of Los Angeles.

Group filters can only be applied from a specific visual or filter snippet. They cannot be applied to a dashboard.

Create the group filter

1. Select the filter icon () or select Settings from the menu () and then select on the sidebar menu.

   The Filters sidebar appears showing any filters that have been applied.

2. Select Add Filter.

3. Select the Group tab and select the numeric field Sales on the tab.

   The Range tab appears in the Filters sidebar. By default, the Aggregation function is set to Sum. You can select other values from the drop-down list.

4. Select the Greater Than operator in the Operator selection box. This allows you to input a threshold value, rather than a value range.

5. Specify a threshold value of 200000 in the Value box.

6. Select Apply.

7. After the visual updates, select Group and then select Product Category. This displays all sales of products totally over $200,000.

8. Remember to save your filter.