|
1. Overview 1.1 Function introduction Dropdown list parameter, whichis list component that provide single-selection or multi-selection. The options for the parameters can be provided by binding any field of any query or manually inputing data. 1.2 Application scenario For example, if you have sales volume data from multiple provinces and want to display the sales volume data of the first province under the province dimension by default when you open dashboard, you can use the drop-down list parameter. 2. Step 1) Create a new dashboard, create a bar chart, bind "province" and "sales volume" and calculate the sales volume summary. 2)Add a drop-down list parameter component, drag and drop the drop-down list parameter component from the component area to the canvas. 3)Bind data to the parameter component, select component, open the right data binding area, drag and drop the "Province" field to bind to the value. ➢Note: Both the value and label of the dropdown list parameter component can only bind one data column. 4) Edit dropdown list parameter component with the following settings: a)Click Setting on the right side, and set layout is Drop-down list, row is 5, column is 3, and check Content Adaption and Bottom Display Button". b)Option Settings: Select "Multi-Selection", check Selection On Top and "Defaults-First Value", and uncheck Commit On Change, and Show All by default. 6)Set filter conditions for the component that need parameter filter, and filter settings are as follows: Select bar chart, click add filter button on the upper-right corner of the bar chart component, and set filter conditions in the Filter dialog as follows: "The province is one of the [? {DropdownList Parameter1}]". 7)Preview or view dashboard, the first value of "Anhui" is selected by default in the drop-down list parameter of the open dashboard, and bar chart will only show the sales data of this province. You can also filter for other provinces, the filter reference and display data are as follows. Click  icon to expand the drop-down list options, uncheck "Anhui", select "Jiangsu" and "Shanghai", click "Apply " button, bar chart data will be changed to show the sales volume of these two provinces. 3. Function 3.1 Input Data [Custom Data] In addition to binding data, you can also input data, click Input Data button in the data area and define the data in the pop-up window. [Data Type] Dropdown to select the data type, the available types include text, numeric, date and time, Boolean, advanced. Advanced includes float, double, character, string, byte, boolean, integer, date, time, timestamp, short, long, bigdecimal. The default data type is text, you can define your own value type according to the parameter you need to pass. For example, we want to filter "Yunnan", "Sichuan", the type of text can be selected. [Add Data Column Value] Check the data column name, add the data column name as a value to the back of the value column to become the value of the parameter component, please refer to Data Process and Analysis > Dynamic Bind for details. [Value] The value of the parameter passed by the actual list parameter. [Label] The label of the parameter value, the label is more conducive to user understanding. If the label is inputed, the label is displayed; if no label is inputed, the value is displayed. [Add] Click add button on the right to input data in the value and label fields. [Delete] Select data row and click t delete button to delete the entered data. [Move Up/Move Down] Select the data row and click move up or move down to change the position of the data. For example, if you set the label "Yunnan Province" for "Yunnan", the drop-down options will show "Yunnan Province". 3.2 Layout 3.3 Option 3.4 Editor [Required] is unchecked by default. If required is checked, the value must be selected before comitting the data. 3.5 Format
| 
