How to use tree filtering

How to use tree filtering

1. Overview

1.1 Function introduction

Tree Filter component is to display filtering options in a tree structure, which can filter multi-layer data. You can bind one field or multiple fields of any query. When you bind multiple fields, the fields are in a hierarchical relationship, and the field bound in front is the parent of the field bound after it.

1.2 Application scenario

If there is a hierarchical relationship between the bound data columns, for example, if there is a column area bound to two dimensions: "Market Size" and "Market", and you want to filter the market size and market at the same time or individually, you can use tree filter.

2.Step

1)Create a new dashboard, create a bar chart, bind "Market Size", "Market", "Sales", as shown below.

2)Add a tree filter component, drag and drop the tree filter component from the component area to the canvas.

3)Bind data to the filter component, select the component, drag and drop the "Market Size" and "Market" columns to the bind data area.

For more information about binding data, please refer toComponent Operation and Setting > Bind Fields, Remove Fields.

4)Edit filter component with the following settings:

Layout: Select List for Layout, and check Expand One Level by Default, so that you can clearly view the filter conditions when you open the dashboard later.

Setting Option: Select Multi-Selection for Option, and check Commit on Change,Show All, Selection On Top, Ignore Null Value, that is, keep the default settings.

For more information about component settings, please refer to Function > Option.

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) When you open the dashboard, you can filter the reference and display data as follows:

Check "Select All" to view the sales of each market under"Big Market" and "Small Market". You can also filter a market by unchecking "Small Market" to view the sales of each market under "Big Market" only.

3. Function

3.1 Layout

For detailed of Layout settings, please refer to Drop-down List Filter > Function > Layout.

3.2 Option

For details of option settings, please refer to Drop-down List Filter > Function> Option.

[Expand One Level by Default] is unchecked by default, after checking, the tree filter and tree parameter component will expand one level option by default when binding multiple fields.

➢Note:

[Expand One Level by Default] option is a setting specific to the Tree Filter and Tree Parameter components, and has been supported by the product since V10.0.1.

3.3 Format

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.