Add a numeric filter to an analysis

Prerequisites

  • You have the Insights Reader license.

  • You have the Insights Author license.

Page location

Insights > Analyses > Click an analysis

Fields with decimal or int data types are considered numeric fields. You create filters on numeric fields by specifying a comparison type, for example Greater than or Between, and a comparison value or values as appropriate to the comparison type. Comparison values must be positive integers and can't contain commas.

You can use the following comparison types in numeric filters:

  • Equals
  • Does not equal
  • Greater than
  • Greater than or equal to
  • Less than
  • Less than or equal to
  • Between

NOTE   To use a top and bottom filter for numeric data, first change the field from a measure to a dimension. Doing this converts the data to text. Then you can use a text filter. For more information, see Add a text filter to an analysis.

For datasets based on database queries, you can also optionally apply an aggregate function to the comparison value or values, for example Sum or Average.

You can use the following aggregate functions in numeric filters:

  • Average
  • Count
  • Count distinct
  • Max
  • Median
  • Min
  • Percentile
  • Standard deviation
  • Standard deviation - population
  • Sum
  • Variance
  • Variance - population

Procedure

Create a numeric field filter

  1. Create a new filter using a numeric field. For more information about creating filters, see Add filters to an analysis.
  2. In the Filters pane, click the new filter. The Edit filter pane opens.
  3. (Optional) Select an aggregation from the Aggregation drop-down list. No aggregation is applied by default.
  4. Select a comparison type from the Filter condition drop-down list.
  5. Do one of the following:

    • If you selected a comparison type other than Between, enter a comparison value in the Enter a value field.

      If you selected Between, enter the beginning of the value range in the Minimum value field and the end of the value range in the Maximum value field.

    • To use an existing parameter, select Use parameters, then select your parameter from the list.

      For parameters to appear in this list, create your parameters first. Usually, you create a parameter, add a control for it, and then add a filter for it. For more information, see Parameters in Insights. The values display alphabetically in the control. If there are more than 1,000 values, the control displays a search box instead. Each time you search for the value that you want to use, it starts a new query. If the results contain more than 1,000 values, you can scroll through the values with pagination.

  6. Select Exclude nulls, Include nulls, or Nulls only from the Null options drop-down list.
  7. Click Apply.

Related topics