1. Overview 1.1 Function introduction ComboBox, a parameter component that provides options in the form of a dropdown list, the dropdown parameter only supports single selection. 1.2 Application scenario For example, if you have sales data from several provinces and you only want to filter out the sales data of a certain province, you can use the drop-down parameter. 2.Step 1)Create a new dashboard, create a bar chart, bind "province", "sales" and calculate the sales sum. 2) Drag and drop combobox component from the component area to the canvas. 3)Bind data to combobox component, select the component, open the data binding interface on the right side, drag and drop the "Province" data column to bind to the value. For example, you can bind the "Province" field to combobox component: 4) Edit combobox component, the specific settings are as follows: a)Click Setting on the right to set the layout: check Content Adaptation, i.e. keep the default settings. b)Set option: set row is 5, the default value in the drop-down box, select "Custom", fill in the input box "Chongqing". 5)Set filter conditions for the components that need parameter filtering, and the filter settings are as follows: Select bar chart created earlier, click the "Add Filter" button on the upper right corner of the bar chart component, and set the filter conditions in the "Filter" pop-up window as follows: "Province is equal to [? {Combobox1}]". 7)Preview or view dashaboard, the default option in the combobox is "Chongqing", and bar chart will only show the sales data of this province. You can also filter other provinces, filter reference and display data as follows: If you want to view the sales volume data of Guangdong Province, click the icon to expand the drop-down list options, slide the scroll bar upward and select "Guangdong". 3. Function 3.1 Layout 3.2 Option Options include row, allow null option, defaults, and required. [Row] Enter a value to define the number of rows in the drop-down list. [Allow Null Option] When checked, there will be one more "Null" in the drop-down options, and you can customize the name of null option. 3.3 Editor By default, the editor is not checked, the following control matches the corresponding control type according to the data type of the bound data, after checking, you can set the rules, pattern detection, Tip for error, mandatory and so on. For details, please refer to Editor. 3.4 Format
|