Menu
Amazon QuickSight
User Guide

Adding a Numeric Filter

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 should not 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

Creating a Numeric Filter

Use the following procedure to create a numeric field filter.

  1. On the data preparation page, expand the Filters pane.

  2. Choose New filter, and then choose a numeric field to filter on.

    This creates a new filter with no criteria.

  3. Choose the new filter to expand it.

  4. Choose a comparison type.

  5. If you have chosen a comparison type other than Between or Not between, type a comparison value.

    If you have chosen a comparison type of Between or Not between, type the beginning of the value range in Minimum value and the end of the value range in Maximum value.

  6. Choose Apply.