This topic describes how to configure a filter bar to query data based on a numeric field.
Prerequisites
A dashboard that contains numeric fields is created.
An empty filter bar is added to the dashboard. For more information, see Create a Filter Bar.
Procedure
Select the created dashboard. It contains the following chart and filter bar.
Click Add Regular Control. In the Set Query Conditions dialog box, perform the following steps.
Set the filter condition name to Quantity Query.
In the Associated Charts and Fields pane, select Line Chart and the order_number field from the drop-down list.
Configure the Query Condition Configuration.
Configuration item
Description
Example
Display Type
When the associated field is a numeric type, you can select either Numeric Input Box or Text Input Box as the display type.
Numeric Input Box
Aggregation Method
Supported methods include Sum, Average, Count, Count Distinct, Maximum, Minimum, Population Standard Deviation, Sample Standard Deviation, Population Variance, and Sample Variance.
Sum
Conditional Form
Supported forms include Single Condition, OR, and AND. If you select Single Condition, you can configure only one filter condition, as shown in the following figure.
AND
Numeric Type
Supports Regular Type and Percentage Type. The default is Regular Type.
Regular Type: Common numeric types, such as integers and decimals.
Percentage Type: When the data display format of the associated field is percentage, you can also select Percentage Type and Set Default Value as a percentage.
Regular Type
Set Default Value
Set the default value for filtering.
>= (Greater than or equal to) 10000
AND
<= (Less than or equal to) 15000
Lock Filter Condition
If you select Lock Filter Condition, you cannot change the filter type on the preview page.
Enable Lock Filter Condition.
Click OK.
In the filter bar, select the query conditions and click Inquire. The chart data will be displayed according to the selected query conditions.
