A hierarchy uses the tree structure to display and organize hierarchical data. It is an implementation of the enumeration method. For example, when reviewing the revenues of the prefecture-level cities in one province, the relationships between the province and prefecture-level cities can be displayed as parent-child structures. Hierarchys are used for analyzing hierarchical data and creating staff organization charts and department organization charts.
A hierarchy contains a sequence of nodes with different labels and metrics. Each node label is determined by data dimensions, such as area and product type. Each node metric is determined by data measures, such as order quantity and order amount.
For each hierarchy, at least two dimensions must be specified to determine node labels. These two dimensions should have a parent-child relationship. At least one measure must be specified to determine the node metric.
The following scenario uses the company_sales_record dataset as an example.
Scenario: Compare the order quantities of different products across provinces and areas
- Log on to the Quick BI console.
- Click Datasets to open the dataset management page.
- Select the company_sales_record dataset and click Create Dashboard.
- Click the hierarchy icon and the corresponding information is displayed.
- Click the Data tab to select data dimensions and data measure.
In the Dimensions list, select Area, Province, and Product Type, and add them sequentially to Node Label. This order determines their hierarchical relationships in the diagram. In the Measures list, select Order Quantity and add it to Node Metric, as shown in the following figure:Note Make sure you have changed the data type of Area and Province from String to Location.
- Click Update to generate the diagram.
- In the Style tab, you can change the title, layout, and design of the diagram.
- Hierarchys support three types of layouts. You can also change the style of tree nodes based on your habits. The root nodes are merged together by default.
- You can edit the levels of hierarchy in the menu bar and manually enter the number of levels. You can specify a primary path based on the field information so that the primary path has a different color to other paths. You can also add a toolbar to the diagram so that you can easily edit the diagram in preview or through the dashboard.
- Click the Save icon to save the dashboard.
To delete the diagram, move the mouse to the upper-right corner and click Delete in the toolbar that appears.