All Products
Search
Document Center

Quick BI:Indicator Diagram

Last Updated:Jan 25, 2024

An indicator diagram describes the relationship between a set of indicators and is commonly used in DuPont analytical models. This topic describes how to add data to a metric relationship chart and configure the style.

Prerequisites

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

Chart overview

  • Use scenarios

    Used in the DuPont analysis model to disassemble and analyze the indicators.

  • Benefits

    • Computing capabilities: You can configure advanced computing, comparison-based comparison, and conditional formats.

  • Exampleimage

Chart field configuration

  • Data Panel

    1. On the Field tab, select dimensions and measures based on your business requirements.

      • In the Measures list, double-click Profit Amt. You can also drag this measure to the Top Indicator (Mea.) field.

      • In the Measures list, double-click Order Amt, Transportation Cost, Cost, Other Costs, Order Quantity, Unit Price, and Discount Point. You can also drag this measure to the Discount Indicator field.

    2. Click Disassembly Relationship to go to the configuration page.

      1. Enter an expression in the Branch Line Expression field to generate a chart in real time. image

        You can split multiple metrics by clicking the field and entering an expression. For example, you can click Order Amount and enter [Order Quantity]*[Unit Price]*[Discount Point] to split the metrics of the order amount. image

        Note

        Enter @ to quickly add indicators. You can enter "+", "-", "*", "," and "( )" on the keyboard.

        Example: Sales performance=Unit price per customer * Number of buyers

      2. Click Save and Exit. The system automatically updates the chart.

        image.png

    3. In the Dimensions list, double-click the order_date (year) field. You can also drag this field to the Comparison Date (Year) field.

      image.png

      1. You can select Latest Date Data and Stage Summary Data as the default values. image.png

      2. After the data is updated, you can go to the Advanced tab to configure the details.

    4. Click Update to create the LBS heat map.

    5. Optional. If you want to view the data of only a few cities, you can configure a filter to filter the required data. image

    6. Auto Refresh

      After you select Auto Refresh, the system refreshes the bubble chart as scheduled. For example, you select Auto Refresh, enter 5, and then select min. The system automatically refreshes chart data every 5 minutes.

Chart style configuration

The following section describes how to configure the chart style. For more information about common chart style configurations, see Configure the chart title.

  • In the Indicator Style section, configure Display Direction and Default Display. 1指标关系

    Parameter

    Description

    Display Direction

    Portrait and Landscape are supported.

    Show by default

    Valid values: Expand All, Collapse All, and Expand to Level N. N indicates the current link level.

  • In the Metric Content section, you can configure the Name and Value text styles. image

  • In the Series Settings section, set Select Series and Prefix and Suffix of Metric Data Value. image

    Parameter

    Description

    Series

    Specify the metric items that are added to the top metric /measure and the area and top split metric /measure.

    Prefix and Suffix for Indicator

    The prefix and suffix for the value of a measure in the indicator trend chart.

  • In the Conditional Format section, configure the conditional format of the field.

    image.png

    Parameter

    Description

    Series

    You can select metrics that are added to the top metric and the area and top disassembled metrics.

    Shortcut Style

    Select marker icons and font colors.

    Custom image styles

    Customize text, icon styles, marker icons, range values, and font colors.

    Synchronize styles to

    Replicate the conditional formatting settings of a measure to other measures.

Chart analysis configuration

Data interaction

Parameter

Description

Redirect

You can use one of the following methods: Redirection within a product, Components within a page, and External link. You can also configure the Redirection icon.

For more information, see Redirect.

image.png

Advanced Settings

If the Comparison Date /Dimension section has a date field and Secondary Metrics is enabled, you can configure the following advanced parameters.

image.png

Parameter

Description

Comparison index selection

One of the date fields in the dataset must be selected.

Compare Content Selection

You can configure Automatic Calculation or Add Fields.

  • Automatic calculation

    A maximum of four comparison fields are displayed based on the granularity of the date field. For example, if you set the Comparison Date parameter to daily granularity, you can set the Comparison Content parameter to daily comparison, weekly comparison, monthly comparison, and yearly comparison. If you set the Comparison Date parameter to monthly granularity, you can set the Comparison Content parameter to monthly comparison and yearly comparison.

    image

  • Add Field

    You can select a field and configure the display name, aggregation method, and data display format of the field.

    image.png

Synchronize and compare metrics

The configuration of the current metric can be displayed to N metrics simultaneously.

Set the secondary indicator font style

The Name and Value text styles are supported. image