Numeric Range Filter

Numeric Range filters are similar to Date Range filters but are available for properties with numeric (integer or double) data types. You can also perform a function on a property so that it results in a number value, such as using the COUNT function. These filters enable you to define numeric ranges and group the results into those ranges.

After selecting the appropriate property and choosing Numeric Range from the Filter drop-down, configure the following properties as needed:

Field	Description
Title	Defines the filter title.
Interval	Defines the number of values in each grouping.
Exclude	Removes the selected property from the results.
Show bars	Displays the total values for the selected property as a bar graphic in the background of the filter.
Show counts	Displays the number of results for the value.
Respond to other filters	Indicates whether the results of this filter change based on selections in other filters on the dashboard.
Format Type	Defines the date format: Automatic (default), 4/18/1984, Apr 18, 1984, April 18, 1984, or Wednesday, April 18, 1984.
Create filter	Creates a subfilter for this filter.

When you have completed the configuration, click OK to create the filter. The new filter appears on the dashboard.

Example

This example uses the following Filter Property and Format settings:

These settings result in the following filter. Each interval is $1,000,000:

This filter has the following options:

Field	Description
[+] show sort details	Reveals the following fields: Sort by: Select Value to sort string values alphabetically, or select Count to order results according to the total number of results for each value. Direction: Select Ascending to order results starting at the top. For strings, the alphabet starts at the top. Or select Descending to order results starting at the bottom.
Designer ()	Click to open the Designer and reconfigure the filter.
Close ()	Click to close the filter and remove it from the dashboard. This action cannot be undone.