Add data to and configure the style of a metric relationship chart-Quick BI(Quick BI)-阿里云帮助中心

Chart Overview

Scenarios

Use this chart for DuPont Analysis to decompose metrics.
Key Benefits
- Calculation capabilities: Supports advanced calculations, period-over-period comparisons, and conditional formatting.
Example Visualization

Limits

Prerequisites: You must have created a dashboard. For more information, see Create a Dashboard.
Field Configuration Limits
- Top Indicator/Measure: Select one core measure field as the top-level analysis target for the relationship chart.
- Decomposition Indicators/Measures: Select multiple measure fields to build calculation formulas. These are the foundational or intermediate metrics used to compute the top-level indicator.
- Comparison Date/Dimension (optional): Select one date-type dimension field. This field is required to enable the period-over-period (secondary metric) feature.
Core Configuration Requirement: You must click the Edit Metric Decomposition Relationship button and enter a mathematical expression to define the calculation logic between metrics. Without a defined formula, the chart cannot correctly display the decomposition relationship.

Procedure

Chart Field Configuration

Data Panel
1. On the Fields tab, select the required dimension and measure fields:
  - In the measure list, find Profit Amount and double-click or drag it to the Top Indicator/Measure area.
  - In the measure list, find Order Amount, Shipping Cost, Cost, Other Costs, Order Quantity, Unit Price, and Discount Factor, and double-click or drag them to the Decomposition Indicators/Measures area.
2. Click Edit Metric Decomposition Relationship to open the configuration interface.
  1. Enter an expression in the Branch Row Expression field to generate the chart in real time.
    
    To decompose multiple metrics, click the field you want to decompose and enter an expression. For example, click Order Amount and enter [Order Quantity]*[Unit Price]*[Discount Factor] to complete its decomposition.
    
    Note
    Type @ to quickly add metrics, and use your keyboard to enter +, -, *and ( ).
    
    Example: Sales Performance = Average Order Value * Number of Customers
  2. Click Save and Exit Editing. The system automatically updates the chart.
3. In the dimension list, find the Order Date (year) field and double-click or drag it to the Comparison Date/Dimension area to enable period-over-period comparisons.
  1. You can choose Latest Date Data or Period Summary Data as the default value for metrics.
  2. After updating the data, go to the Advanced tab to configure period-over-period details.
4. Click Update. The system automatically refreshes the chart.
5. (Optional) To view data for only specific cities, set a filter to include only the desired data.
6. Auto-refresh
  
  When enabled, the system refreshes the chart data at a specified interval. For example, setting the interval to 5 minutes refreshes the data every 5 minutes.

Chart Style Configuration

The following sections cover style settings specific to the metric relationship chart. For general chart styling options, see Configure the chart title.

Metric Block Style

In Metric Block Style, configure Display Direction and Default Expansion.

Configuration Item	Description
Display Direction	Supports portrait and landscape.
Default Expansion	Options include Expand All, Collapse All, and Expand to Level N, where N matches your current relationship level.

Metric Content

In Metric Content, configure text styles for Name and Value.

Series Settings

In Series Settings, configure Select Series and Metric Value Prefix/Suffix.

Configuration Item	Description
Select Series	Set the measures added to the Top Indicator/Measure and Decomposition Indicators/Measures areas.
Metric Value Prefix/Suffix	Set prefixes and suffixes for metric values displayed on the chart.

Conditional Formatting

In Conditional Formatting, configure conditional formats for fields.

Configuration Item	Description
Select Field	Select a measure field to apply conditional formatting. Any measure added to the Indicator/Measure area is available for selection. To remove conditional formats, click Batch Clear Format in the lower-right corner of the field panel, select the formats to remove, and click OK.
Quick Styles	Choose from system-provided styles to set marker icons or font colors for the current measure field. Comparison: Options include Compare with 0 and Compare with Mean. Color Flip: For example, with "Compare with 0", values below 0 appear red and above 0 appear green. After flipping, values below 0 become green and above 0 become red. Delete: To remove a quick style, click Delete.
Custom Styles	You can also configure custom styles for the current measure field. Text: Define rules to display field values in a specified style, visually highlighting key data in the chart. Configure the following: Based On Field: The data field that the condition rule applies to. Defaults to the field selected under Select Field. You can choose another measure field to create rules based on its values. Condition Type: Set the comparison basis. Options include Compare with Static Value and Compare with Dynamic Field. Condition Rule: Define the logic for evaluating the condition and specify the text style (color, bold, italic) when the rule is met. Add Rule: Click to add a new rule. Icon: Display marker icons next to data points based on comparison results, showing how current values relate to target values. Configure the following: Based On Field: The data field that the condition rule applies to. Defaults to the field selected under Select Field. You can choose another measure field to create rules based on its values. Condition Type: Set the comparison basis. Options include Compare with Static Value and Compare with Dynamic Field. Condition Rule: Click the Marker Icon dropdown and select an appropriate icon from the system-provided set. Define the logic that triggers each icon, and assign a unique icon to each comparison rule if needed. Add Rule: Click to add a new rule.
Sync Style To	Apply the current conditional format to other measure indicators.

Chart Analysis Configuration

Data Interaction

Configuration Item

Description

Navigation

Navigation includes three methods: in-product parameter navigation, in-page component navigation, and external links. You can also configure a navigation icon.

For details, see Navigation.

Secondary Metrics

When Secondary Metrics are enabled, you can configure the following.

Configuration Item	Description
Comparison Metric Selection	Select the measure fields for which you want to configure secondary metric comparisons.
Secondary Metric Content	Configure the specific content for secondary metric comparisons. Based on the date field granularity configured in Date/Dimension, the system automatically generates period-over-period options. For example, if the date field is at day granularity, options include day-over-day, week-over-week, and month-over-month. If no date field is configured in Date/Dimension, you must manually add a secondary metric field. You can: Click the checkbox icon to select up to two secondary metrics for display. Click Add Field to open the Add Field dialog and define custom secondary metrics, including their aggregation method, display format, and conditional formatting. Drag the icon to reorder metrics and adjust their display sequence in the chart. Click the icon to open the Secondary Metric Content Settings dialog and adjust the display format and conditional formatting for the selected metric.
Sync Configuration to Other Comparison Metrics	Select other measure fields to apply the current secondary metric configuration.
Set Secondary Metric Font Style	Configure text styles for Name and Value.

FAQ

1. What is the main difference between a metric relationship chart and a metric decomposition tree?

Answer: Both decompose metrics, but in different ways. A metric relationship chart displays calculation and composition relationships based on manually defined mathematical formulas, emphasizing computational logic — commonly used in models like DuPont Analysis. A metric decomposition tree decomposes metrics by dimension, drilling down layer by layer to show how different dimension members contribute to and represent proportions of the whole, emphasizing dimensional segmentation.

2. How do I define a calculation relationship between metrics? For example, A = B × C?

A: On the Field configuration tab, add measures A, B, and C to their respective areas (A is usually placed at the top, and B and C in the breakdown area), and then click Edit Measure Breakdown Relationship. In the dialog box, find the node for measure A (or use the input box at the top if it is a top-level measure) and enter the expression [B]*[C]. You must use square brackets ([ ]) to enclose the measure names.

3. How do I display the year-over-year (YoY) and month-over-month (MoM) change for each metric?

Answer: First, ensure a date dimension field with year-month information is added to the Comparison Date/Dimension area on the Fields tab. Then switch to the Analysis configuration tab, find Secondary Metrics, and enable it. In Secondary Metric Content, check the system-generated Month-over-Month and Month-over-Month Growth options (if available). For custom calculations, click Add Field to configure them.

4. The chart does not appear or shows incorrect relationships. What could be wrong?

Answer: The most common cause is incorrect or missing metric decomposition relationships. Ensure you click Edit Metric Decomposition Relationship and verify that correct calculation formulas are entered for all metrics requiring decomposition. Also confirm that all underlying metrics involved in the calculation have been added to the Decomposition Indicators/Measures area.