|
1. Overview 1.1 Function introduction Range filter provides options in the form of sliders, which can be single-point or interval range selections. Range filter can bind any query to a discrete or numeric type of field that is not available to aggregate functions. 1.2 Application scenario Filter the numeric fields of other components in the dashboard, for example, filtering the data of "Profit" in the range of [0,800] with an interval of 100. 2. Step 1) Create a new dashboard, create a table, bind "Product Name" and "Profit", and switch to detail mode. 2) Add a range filter component, drag and drop the range filter component from the component area to the canvas. 3) Bind data to range filter component, select the component, drag and drop the "Profit" column to the binding area. 4) Edit range filter component with the following settings: a)Click Setting > Option on the right to set options. b)Slider type is Range, i.e. keep the default, and the size is set to 2. c)Click  icon or Range text, pop-up range dialog box, the default range rules for the range, define the scale settings in the minimum value of 0, the maximum value of 800, that is, to maintain the default, set the step value of 100. define the range to include the range of the left border and the right border. d)Click Apply to make sure the settings are as expected, then click Confirm to close the Range dialog box. 5) Preview to see the filtering effect. You can double-click the range data above the slider. You can also enter values in the text box to define the range to be displayed, the effect is shown as below: ➢Note: If it is bound to a numeric value, when you input the value, it will be positioned to the nearest scale to the value, for example, the step in the above figure is 200, input 210, it will be positioned to 200. If the binding is text or datetime, you need to input the data that exists, for example, when you input tea but no tea exists, the slider range will not change. 3. Function 3.1 Slider [Slider] The slider display includes range and single-selection, related to the type of data bound. [Single-Selection]each scale of the slider corresponds to one data, usually used to filter text data, such as Product Type. [Range] two scales of the slider are used to define an interval range to filter out the data within the range, which is usually used to filter numerical data, such as sales volume. Different data types support different slider types and range rules, please refer to the following table. Function Range Rule Slider Type Description
Numeric Range Range Numeric data is continuous by default, the range rule is range by default, you can adjust it to discrete or group in Setting > Range, for example, number, you can set it to discrete, or you can customize group, for example, 0-10, 10-100, etc., depending on the actual analysis scenario.
Discrete Range, Single-Selection
Group
Text Discrete
DateTime Only discrete can be set as the range rule for date-time and text-type data.
[Slider] Select the slider to display as range. [Size] Set the size of the selected range, the unit of calculation is the number of scales, and the starting point of the calculation is the current starting point. Assuming that the starting point is 0, the step is 200, set the size to 1, the results are shown below: If you set the size to 2, the size of the selected range is 2 scales, as shown in the following figure: [Show Scale] is unchecked by default, and the scale is displayed on the slider after it is checked. [Required] is not checked by default. When checked, the component is required . When there are multiple parameter components or filter components participating in the filtering, the data can be filtered out only if all required components have selected values. 3.2 Range In the right panel of the range filter component, Setting > Option > Range, you can open the range property dialog box of the component, as shown below. a) Select Discrete, each label and scale of the range filter component is an actual data value, and the range is a left and right closed interval. Only discrete can be selected for text, datetime data. b)Select Range, you can define the minimum and maximum values of the range filter component and define the step size. The rules are configured as follows: •Define Scale [Min] The minimum value displayed by the scale. [Max] The maximum value displayed by the scale. [Step] Enter the corresponding step value. If the minimum value of the value is 1, the maximum value is 10, and the step is 2, the data will be selected from the values 1, 3, 5, 7, and 9. •Define Range [Include values less than min] When the user checks this item, assuming that the minimum value is defined as 3, the step is 1, the step will be generated in accordance with the length of a more than a range of 2 to 3, the query data exists in -1, -3 and other values less than 3, select the range of less than min, the less than 3 of all the data can be checked out. [Include values more than max]Referring to the range include values less than the min, the same reason can be obtained, when there is a maximum value greater than the definition, will be in accordance with the step length of more than one generated a range, select this range can be greater than the maximum value of all the data to check out. [Include left boundary] Suppose the user selects a range of 3 ~ 6, then the filtered data contains 3 but not 6, and contains right boundary of the range in the same way. c) Select Group, user-defined scale values are allowed, and the left and right boundaries of the range are grouped respectively, the rules are configured as follows: •Define Scale [Add] Add the customized scale in the input box. [Delete] Remove the added scale. [Label] Set an alias for the added scale range. •Define Range It is the same as selecting range, so we will not repeat description here, please refer to the selecting range. Please refer to the following animation for the setting method: 3.3 Animation 3.4 Format
| 
