This topic provides an overview of decomposition tree charts and an example on how to use decomposition tree charts. This topic also describes how to configure decomposition tree chart styles and how to delete a decomposition tree chart. Decomposition tree charts are available only in workspaces of the Quick BI Enterprise Standard edition.

Prerequisites

A dashboard is created. For more information, see Create a standard dashboard.

Overview

A decomposition tree chart allows you to split core indicators and identify key factors or members that affect these indicators. For example, you can use a decomposition tree chart to view the contribution of each member in a group. You can also split a measure into one or more groups and analyze data in each group.

When you create a decomposition tree chart, you must specify Analysis Object (Measure) and Decomposition Basis (Dimension).
  • You can specify one to five dimensions for Decomposition Basis (Dimension).
  • You can specify only one measure for Analysis Object (Measure).
Decomposition tree chart - 3.11
Notice A decomposition tree chart can have up to 5 columns and 50 rows.

Example

The following example shows how to use a decomposition tree chart. In this example, the company_sales_record dataset is used.
  1. Perform the operations shown in the following figure to create a dashboard. Create a dashboard
  2. In the Create Dashboard dialog box, select Standard or Full Screen, and click OK.
    In this example, Standard is selected. Confirmation message
  3. On the dashboard edit page, click the Division of square paper icon in the top menu bar and click the Decomposition Tree icon. Decomposition tree chart
  4. On the Data tab, select dimensions and measures based on your business requirements.
    • In the Dimensions list, double-click area, province, and product_type. You can also drag these dimensions to the Decomposition Basis (Dimension) field.
    • In the Measures list, double-click order_number. You can also drag this measure to the Analysis Object (Measure) field.
  5. Click Update to update the decomposition tree chart. 311

    You can click the 1 icon next to Analysis Object (Measure) to modify the display name, aggregation method, and value display format of a measure. For more information, see Configure a chart.

  6. Configure the items and indicators that you want to split.
    1. On the edit page of the decomposition tree chart, move your pointer over the Add icon. Add 2
    2. Then, choose a method to split indicators.
      • Custom splitting: You can split the dimensions that you added to the Decomposition Basis (Dimension) field on the Data tab. Split dimensions based on your business requirements.
        In this example, you can split dimensions by area, province, or product_type. User split - 3.11
      • Smart splitting: You can select High Contribution or Low Contribution. Quick BI can use AI to help you split data.
        In this example, Low Contribution is selected. Smart splitting - 3.11
        Note If you select Smart splitting, the splitting path is product_type > province. After you save the dashboard, this splitting path is also saved. When you open the dashboard next time, the default path is product_type > province. If you want to check the latest smart recommendation result, you can modify the settings in the dashboard.
    3. Change the indicators that you want to split.
      In this example, you need to change province to product_type.
      1. Click the Delete icon next to province. Delete - 3.11
      2. Move your pointer over the plus sign next to the required section and select product_type. Change - 3.11
      • If you want to hide an indicator, click the Hide icon next to its parent node.
      • If you want to show an indicator, click the Hide icon again.
  7. On the Style tab, modify parameter settings in the Basic Information, Chart Style, and Functionality sections.

    For more information, see Configure decomposition tree chart styles.

  8. On the Advanced tab, configure the following parameters. Advanced settings
    Parameter Option Description
    Advanced Settings Auto Refresh After you select Auto Refresh, the system refreshes the decomposition tree chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the decomposition tree chart every 5 minutes.
    Filter Interaction After you configure Filter Interaction and click an area or field in the decomposition tree chart, data in other charts that are associated with this chart is updated. For more information, see Configure the filter interaction feature.
  9. Click Save in the upper-right corner of the page to save the settings.

Configure decomposition tree chart styles

  • In the Basic Information section, configure Show Title and Description, Description, Endnote, and Show Link.
    Note If Show Link is selected, you also need to configure Link Text and Link Address. If you click a field in the decomposition tree chart, you are redirected to the linked report or an external link.
  • In the Chart Style section, configure Color Logic and Splitting Logic. Chart style
    Parameter Description
    Color Logic The color for a measure that you added to the Analysis Object (Measure) field.
    Splitting Logic The method of using doughnut charts to show the percentages of different values. Options: Parent, Root, and Max.
    • Parent: A node that has child nodes is a parent node.
    • Root: A node that does not have a parent node is a root node.
    • Max: A node that ranks first in each column is a max node.
  • In the Functionality section, configure Enable AI Splitting based on your business requirements.
    If you select Enable AI Splitting, Absolute Analysis is selected by default. The following figure is an example of the decomposition tree chart after you select Enable AI Splitting. Enable - 3.11
    If you select Absolute Analysis, absolute values are analyzed. In this example, the order_amt measure is used, and the province and product_type dimensions, such as technical product, furniture product, and office supply, are split.
    • If you select High Contribution, product_type is split. The product with the largest order amount ranks first. In this example, the technical product category ranks first because it has the largest order amount. Smart splitting - 3.11
    • If you select Low Contribution, province is split. The province with the smallest order amount ranks first. In this example, Qinghai province ranks first because it has the smallest order amount. Smart splitting - 3.11
The following figure shows the updated decomposition tree chart. Decomposition tree chart - 3.11

Delete a chart

  1. Click the More icon in the upper-right corner of the line chart.
  2. Select Delete. The line chart is deleted.