Filter bar controls support numeric field queries. This topic describes how to configure a filter bar for numeric fields.
Prerequisites
-
A dashboard containing numeric fields is created.
-
An empty filter bar is added to the dashboard. Create a filter bar.
Procedure
-
Open the dashboard that contains the target chart and filter bar.
-
Click Add Regular Control and configure the Set Query Conditions dialog box.
-
Set the filter condition name to Quantity Query.
-
Select Line Chart as the associated chart and order_number as the associated field.
-
Configure the Query Condition Configuration settings.
Configuration item
Description
Example
Display Type
Select Numeric Input Box or Text Input Box as the input type for numeric fields.
Numeric Input Box
Aggregation Method
The aggregation method applied to the numeric field. Options: Sum, Average, Count, Count Distinct, Maximum, Minimum, Population Standard Deviation, Sample Standard Deviation, Population Variance, and Sample Variance.
Sum
Conditional Form
The logical relationship between filter conditions. Options: Single Condition, OR, or AND. Single Condition allows only one filter condition.
AND
Numeric Type
Options: Regular Type (default) and Percentage Type.
-
Regular Type: Standard numeric values, such as integers and decimals.
-
Percentage Type: Suitable when the associated field is displayed as a percentage. You can set a percentage as the default value.
Regular Type
Set Default Value
Specify the default filter value.
>= (Greater than or equal to) 10000
AND
<= (Less than or equal to) 15000
Lock Filter Condition
When enabled, users cannot change the filter type on the preview page.
Enable Lock Filter Condition.
-
-
-
Click OK.
-
In the filter bar, specify the query conditions and click Inquire. The chart refreshes based on the specified filter criteria.
