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 list, 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 $100:
This filter has the following options:
| Field | Description |
|---|---|
| [+] show sort details | Reveals the Direction field where you can toggle the sort order between ascending and descending. |
Select All Visible ( ) |
Selects all of the items that are displayed in the filter. |
Designer ( ) |
Click to open the Designer and reconfigure the filter. |
| Close (X) | Click to close the filter and remove it from the dashboard. This action cannot be undone. |