Dropdown List Parameter：Dropdown List Parameter - vividime Community

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.

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.

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.

In addition to binding data columns, you can also input data, please refer to Dropdown List Parameter > Function > Input Data for details.

Both the value and label of the dropdown list parameter component can only bind one data column.

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.

For more information about component settings, please refer to Dropdown List Parameter > Function.

5)Save dashboard, click the "Save" button on the upper right corner of the page, and set the file name in the Save dialog . For more information about dashboard saving, please refer to Dashboard Operation and Setting > Save, Save As, Auto Save.

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.

[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 toData 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".

For detailed of layout settings, please refer to the Dropdown List Filter > Function > Layout.

For details of option settings, please refer to Dropdown List Filter > Function > Option.

[Required] is unchecked by default. If required is checked, the value must be selected before comitting the data.

You can also set the style of the component in Format on the right side, including text, border, background color, alpha, etc. For details, please refer to Component Operation and Setting > Format.