1. Overview 1.1 Function introduction Tree parameter component is a tree structure to display the options, and it can pass the value of each tree node separately for parameter assignment. Tree parameter component is usually used in conjunction with auto-loop, for more details please refer to Self-Service Dataset > Auto Loop. 1.2 Application scenario There exists a data with hierarchical relationship, for example, origin has three hierarchical levels: "marketv size - market - province", when you want to display the market size, market and province at the same time or individually, you can use the tree parameter. The data structure is as follows: 2. Step 1)Create a new dashboard, create a bar chart, and bind "Origin" and "Profit" as shown below。 2)Add a tree parameter component, drag and drop the tree parameter component from the component area to the canvas. 3)Process the "Origin" column as a self-looping column according to Hierarchy Length 2, and configure the self-looping column as shown below: Generate 3 levels of data as shown below: Bind these 3 columns to the tree parameter as shown below. ➢Note: Please bind the self-looping columns level1, level2 and level3 instead of the original column "origin" to ensure the options are displayed as a tree. 4)Edit the parameter components, the specific settings are as follows: a)Click on the right side of the [Settings], layout settings: Layout check the "List". b)Options Settings Options check "Multiple-Selection", check the "Comit on Change", "selection on Top", that is, to maintain the default settings. 5)Set the filter conditions for the bar chart, and the filter settings are as follows: Select the bar chart component, click "Add Filter" in the upper right corner to set the filter conditions: origin containss one of [? {TreeParameter 1}], as shown below: 7) Preview to see the effect of parameter filtering. 3. Function 3.1 Layout 3.2 Option 3.3 Editor [Required] is unchecked by default. If required is checked, the value must be selected before comitting the data. 3.4 Format
|