Setting a Numeric Field Filter
You can filter visual data by the values in a numeric field.
To set a filter for a numeric field:
- To access the visual filter sidebar, select its filter icon () or select Edit Visual from the visual 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.
Select the Row tab. If the style of your visual is an arc gauge, KPI chart, raw data table, 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 or visual. See Maintaining Saved Filters.
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 Accessing the Derived Field Editor from the Filters Sidebar and Accessing 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.
The Keyset tab allows you to select a keyset to apply as the filter (see Using Keysets).
After the filter specifics have been specified, select . If you create the filter at the dashboard level, it is applied to all the visuals in the dashboard. Otherwise, it is applied only to the selected (active) visual.