(v24) Set a Numeric Field Filter

Set a Numeric Field Filter

This applies to: Visual Data Discovery

You can filter visual data by the values in a numeric field.

Set a filter for a numeric field

1. Select the filter icon on the visual, filter snippet, or dashboard to access the appropriate filter sidebar.

   • To access the filter sidebar, select its filter icon () or select Settings from the menu () and then select on the sidebar menu.

   • To access the dashboard filter sidebar, select its filter icon (). The dashboard-level filter icon is available only when all the visuals are from the same data source.

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

2. Select the Row tab. If the style of your visual is an arc gauge, KPI chart, table (raw data), histogram, or map markers chart, the Group tab is available, but you cannot create a group filter because all filters for these visual styles are row-level filters. If you are using the dashboard filters sidebar, the Group tab is not available.

   The Saved tab shows saved filters that you can apply to a dashboard, visual, or filter snippet. See Maintain Saved Filters.

3. On the Row tab, select a numeric field you want to use from the list of available number fields. A second page with two tabs appears in the Filters sidebar: Range and Keyset.

   You can also select to access the Derived Field Editor or the Custom Metrics Editor to create or modify derived fields and custom metrics to be used as filters. See Access the Derived Field Editor from the Filters Sidebar and Access the Custom Metrics Editor from the Filters Sidebar.

   Tab	Description
   Range	Select a relational comparison operator in the Operator selection box. Data is included in the visual when the data in the filter field meets the condition set by the relational operator and the numeric values you specify. Valid numeric operators are described in Operators. The Range tab initially shows the full range of values available. It provides an Operator selection box and From and To boxes for you to use to select the range of values. Use the arrows in the From and To boxes to increase and decrease the maximum and minimum values.
   Keyset	The Keyset tab allows you to select a keyset to apply as the filter (see Use Keysets).

4. After the filter specifics have been defined, select Continue. If you create the filter at the dashboard level, it is applied to all the visuals and filter snippets in the dashboard. Otherwise, it is applied only to the selected (active) visual or filter snippet. After confirming your changes, select Apply.