Setting a Numeric Field Filter

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

To set a filter for a numeric field:

  1. Click the filter icon () on the chart or dashboard or select Filters from the chart menu (). The dashboard-level filter icon is available only when all the charts are from the same data source.

    The Filters sidebar appears.

  2. Click . Three tabs appear allowing you to select a row-level filter, a group filter, or a saved filter.

  3. Select Row and then select a numeric field you want to use from the list. The Filters sidebar allows you to select a range of values that should be displayed on the chart for the numeric field or a keyset.

  4. Two tabs are shown on the Filters sidebar that you can use to set a range of values: Range and Keyset. Instructions for creating a filter using each of these tabs is described in the following table.

    Tab Description

    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.

    Select a relational comparison operator in the Operator selection box. Data is included in the chart 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 Keyset tab allows you to select a keyset to apply as the filter (see Using Keysets).

  5. After the filter specifics have been specified, click . If you create the filter at the dashboard level, it is applied to all the charts in the dashboard. Otherwise, it is applied only to the selected (active) chart.