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 in a Visual or Dashboard
-
Select the filter icon on the visual or dashboard to access the appropriate filter sidebar.
To access the filter sidebar, select its filter icon
or select Settings from the Show More menu (
) and then select the filter
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 opens, showing currently applied filters, if any.
Select Add Filter. An Add Filter work area opens to the Row tab, and includes Group and Saved tabs.
-
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.
-
On the Row tab, select the numeric field you want to use from the list of available number fields. A Select Values work area opens that you can use to select values and define this filter's specifics. See the table below for available options.
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).
Note: You can also select the add iconto 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.
-
After you have defined the filter specifics, select Continue. After confirming your changes, select Apply.
Filters you create at the dashboard level are applied to all the visuals in the dashboard that use that source.
Filters you create at the visual level apply only to the selected (active) visual.
Note: Optionally, nest multiple filters for more targeted filtering results. Select Nest Filters, then link multiple filters using AND
and OR
filtering.
Additional Numeric Field Filters in a Filter Snippet
When you create a new filter snippet, you define the initial data type, operator, data source, and value column to use in Data Settings. You can add additional filters, including nested filters, as needed.
Open your existing filter snippet.
Select the Filters option from the Filter Snippet sidebar.
Select Add Filter. An Add Filter work area opens to the Row tab, and includes Group and Saved tabs.
-
Select or create a field to filter from available options on the Row or Group tab.
Select an existing available field from Attribute, Number, Time, or Hierarchy and define appropriate options to use.
Alternatively, elect the add icon to add a derived field or custom metric, and define appropriate options to use.
After you have defined the filter specifics, select Continue. After confirming your changes, select Apply.
Note: Optionally, nest multiple filters for more targeted filtering results. Select Nest Filters, then link multiple filters using AND
and OR
filtering.
Comments
0 comments
Please sign in to leave a comment.