Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Set a Numeric Field Filter

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 or dashboard to access the appropriate filter sidebar.
    • 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.
  2. The filters sidebar appears showing any filters that have been applied.
  3. 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.
  4. The Saved tab shows saved filters that you can apply to a dashboard or visual.
  5. 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.
  6. You can also select to access the Create Derived Fields or the Create Custom Metrics to create or modify derived fields and custom metrics to be used as filters.
    TabDescription
    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.

  7. After the filter specifics have been specified, select Apply. 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.

Published:

Set a Numeric Field Filter

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 or dashboard to access the appropriate filter sidebar.
    • 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.
  2. The filters sidebar appears showing any filters that have been applied.
  3. 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.
  4. The Saved tab shows saved filters that you can apply to a dashboard or visual.
  5. 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.
  6. You can also select to access the Create Derived Fields or the Create Custom Metrics to create or modify derived fields and custom metrics to be used as filters.
    TabDescription
    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.

  7. After the filter specifics have been specified, select Apply. 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.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk