All Products
Search
Document Center

Quick BI:Decomposition Tree Chart

Last Updated:Feb 24, 2025

The decomposition tree chart is instrumental in pinpointing key channels or members that impact core metrics by breaking them down. It enables easy visualization of each member's contribution across multiple dimensions to the overall metrics. Additionally, it allows for the breakdown of measures into one or more groups for detailed group data analysis. This topic describes the steps to add data to a decomposition tree chart and configure its styles.

Prerequisites

A dashboard has been created. For more information, see Create a Dashboard.

Overview

Scenarios

Often used to break down a value into multiple groups to determine the proportion between groups.

Example Diagram

image

Configure a Decomposition Tree Chart

  1. In the Data tab, select the required dimension fields and measure fields:

    • In the Dimension list, find Region, Province, and Product Type, and double-click or drag them to the Decomposition Basis (dimension) area in sequence.

    • In the Measure list, find Order Amount, and double-click or drag it to the Analysis (measure) area.

  2. Click Update. The system automatically updates the chart.

    image..png

Decomposition Analysis

After configuring a decomposition tree chart, data analysts and users can set decomposition items and analyze data on the chart.

  1. On the decomposition tree chart editing page, hover the mouse over the node icon, as shown in the following figure.

    image

  2. Select the form of decomposition:

    • Custom decomposition: The decomposition dimensions displayed on the interface are the fields added to the Decomposition Basis (dimension) in the Data tab. Users can select the decomposition dimensions according to their needs.

      In this example, decomposition by Region, Province, or Product Type is supported.

      image

    • Intelligent decomposition: Supports two dimensions: High Contribution and Low Contribution. AI intelligently decomposes based on the selected data.

      In this example, decomposition is performed by High Contribution.

      image

      Note

      If you use Intelligent Decomposition, the decomposition path is set to Product Type > Province. After saving the dashboard, this intelligent decomposition path will be saved. When you reopen the dashboard, the default decomposition path is still Product Type > Province. If you want to see the latest AI recommendation results, you can continue to edit the dashboard.

  3. Modify decomposition items.

    For example, you need to change the intelligent type Province to the custom type Product Type.

    1. Click the delete icon on the right side of the Province area, as shown in the following figure.

      image

    2. Hover the mouse over the target area to select Product Type.

      image

Configure the Chart Style

The following describes the style configuration of the chart. For general chart style configuration, see Configure the Chart Title.

You can quickly find configuration items for configuration by entering keywords in the search box at the top of the configuration area. At the same time, click the right image..png chart to support the operation Expand/Collapse All Categories.

指标拆解树-搜索..gif

Node

In Node, set Visualization Color Configuration and Visualization Split Logic.image

Chart configuration item

Configuration item description

Positive and negative value coloring

For the measure item in the Analysis (measure) area, configure the color based on the positive or negative value.

111

Split Logic

Set the statistical method of the value proportion in the ring chart. Supports Parent Node, Top-level Node, and Highest Node.

  • Parent Node: If the current node contains child nodes, it is a parent node.

  • Top-level Node: If the current node has no parent node, it is a top-level node.

  • Highest Node: If the current node is the topmost node in the column, it is the highest node.

    指标拆解树-拆分逻辑..gif

Display Proportion

Supports configuring whether to display the proportion.

image..png

Enable AI Split

Set whether to Enable AI Split function. The AI analysis type supported by the system is Absolute Analysis. After enabling this function, it is displayed as follows.

image

Absolute Analysis: That is, the absolute value of the analyzed value. In this example, the measure item is Order Amount, and the decomposition dimensions are Province and Product Type (such as Technical Products, Furniture Products, and Office Supplies):

  • If High Contribution is selected, decomposition is performed based on Product Type, and the product with the largest order amount is decomposed (in this example, Technical Products have the largest order amount).

    image

  • If Low Contribution is selected, decomposition is performed based on Province, and the province with the smallest order amount is decomposed (in this example, the province with the smallest order amount is Yunnan).

    image

Conditional Format

In conditional format, configure the conditional format of measure fields.

image

Chart configuration item

Description

Select a field

Select the measure field that needs to be configured with conditional format. Only measures added to the field panel analysis (measure) area can be selected.

Conditional format

Quick style

Select the quick style, click to select the style type, and you can choose the conditional format of the current measure field from the system styles in the drop-down list.image

  • Comparison: Supports selection for comparison with 0.111

  • Color flip: Take comparison with 0 as an example. Less than 0 is red, greater than 0 is green. After flipping, less than 0 is green, greater than 0 is red.111

  • Clear: When a quick style that has been set is no longer needed, click Clear to remove the style.111

Custom style

In addition to the quick styles provided by the system, you can also configure custom styles for the current measure field as needed. Supports setting conditional format by comparing with a static field.

  • In the Highlight Text/Background tab, set the condition rule for displaying the text of the current measure field as a highlight color.image

  • In the Icon tab, set the icon marking rule for the current measure field under different conditions.image

  • In the Ring tab, set the ring display color rule for the current measure field under different conditions.image

Configure Chart Analysis

Configuration item

Name

Description

Interactive analysis

Filter Interaction

If the data that you want to analyze exists in different charts, you can click the Edit icon next to Linkage and configure the parameters in the Filter Interaction dialog box. Charts can be associated for data analysis. For specific settings, see Filter interaction.

Limits

The decomposition tree chart consists of Analysis (measure) and Decomposition Basis (dimension):

  • The decomposition basis is determined by the dimension of the data. At least one dimension must be selected, and up to ten dimensions can be selected. For example, Region, Province, City, and Product Name.

  • The analysis is determined by the measure of the data. Up to one measure can be selected. For example, Order Quantity and Sales Amount.

Important

When decomposing fields in the decomposition tree chart, the vertical display does not exceed ten rows, and the horizontal display does not exceed 500 columns.

What to Do next

  • When others need to view the dashboard, you can share the dashboard with specific people. For more information, see Share a Dashboard.

  • When you need to create a complex dashboard with a navigation menu for thematic analysis, you can integrate the created dashboard into the BI portal. For more information, see BI Portal.