All Products
Search
Document Center

Quick BI:Indicator Trend Chart

Last Updated:Jan 21, 2025

An indicator trend chart displays the latest values of multiple metrics, their aggregated values over a period, and their trends. This topic explains how to add data to an indicator trend chart and configure its style.

Prerequisites

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

Chart Overview

Scenarios

In certain scenarios, monitoring metric changes is crucial to detect anomalies in your business operations.

Advantages

  • Computing Power: Easily configure advanced calculation features to compare current values with historical data.

  • Data Visualization: Enhance your chart with logos and customize settings such as background, font size, and color.

  • Additional Features: Include annotations like text and metrics, and insert hyperlinks to connect metrics with other platforms.

Example of Effect Diagram

Indicator Trend Chart

Chart Data Configuration

  1. In the Field tab, select the necessary dimension fields and measure fields:

    • From the Dimension list, locate the order date (day), then double-click or drag it to the Date/Dimension area.

    • In the Measure list, find metrics like order quantity, order amount, shipping cost, and profit amount, and sequentially double-click or drag them to the Indicator/Measure area.

  2. Select Default Indicator Value and click Update. The chart will automatically refresh.

    • Latest Date Data shows the data for the most recent time point within the selected interval.

      Selecting Latest Date Data displays the data for the last day (20161230).

      image..png

    • Stage Summary Data shows the aggregated data for the selected interval.

      Selecting Stage Summary Data displays the summarized data for the interval (20161201~20161230).

      image..png

Chart Style Configuration

Below are the style configuration steps for the indicator trend chart. For general chart style settings, see configure the chart title area.

Enter keywords into the search box at the top of the configuration area to swiftly locate configuration items. Additionally, you can click image..png on the right side of the chart to toggle the expand/collapse all categories operation.

Indicator Trend Chart Search

  • In the trend chart, you can configure settings such as the chart type, visualization options, and color preferences. image

    Chart configuration items

    Configuration item description

    Trend chart type

    Supports two types: display trend chart, indicator with small trend chart.

    4567

    Visualization Chart Switch

    Supports switching between line chart, area chart, column chart. 3

    Color settings

    Set the overall color scheme of the indicators. Supports setting a specified color for each indicator according to actual needs.

    111

    Line type

    (Line chart/area chart scenario)

    Supports curve, straight line.

    Line style

    (Line chart/area chart scenario)

    Set the line type and thickness of the lines.

    Display marker points

    (Line chart scenario)

    Set whether to display marker points and customize the shape of marker points. image

    Empty value processing

    (Line chart/area chart scenario)

    Supports setting three methods: directly skip, set to 0 without breaking, and line break.

    Date Interval Setting

    The default is 30 days.

    Display legend

    Set whether to display the legend.

    image

    Note

    This option appears only when display trend chart is selected.

  • In the indicator layout section, choose the layout style for the indicator blocks.

    • When trend chart type is set to display trend chart, apply the following settings.

      image..png

      Chart configuration items

      Configuration item description

      Indicator Block Group Display Form

      When multiple indicator interfaces cannot be fully displayed, you can slide to display other indicators by Left And Right Sliding, or Line Break Tiling to display all indicators. You can also set the number of indicator blocks per row on the indicator trend chart.

      image..png

      Note

      This option appears only when trend chart is enabled.

      Background color

      Set the background color of the indicator block. Supports two methods: transparent and solid color.

      Indicator block spacing

      Set the spacing of the indicator block.

      Indicator block height

      Set the height of the indicator block by defining the distance between the indicator content and the indicator block.

      Indicator and trend chart interaction

      Supports Single Selection and Multiple Selection.

      • Single Selection: Indicates that only one measure indicator trend chart can be displayed.

      • Multiple Selection: Indicates that multiple measure indicator trend charts can be displayed simultaneously.

        Note

        This option appears only when Trend Chart Is Enabled.

        指标趋势图-指标交互

    • Upon selecting the trend chart type as indicator with small trend chart, proceed with the following configuration. image.png

      Chart configuration items

      Configuration item description

      Indicator Block Group Display Form

      Supports setting the number of indicator blocks per row on the indicator trend chart.

      41.gif

      Note

      This option appears only when trend chart is enabled.

      Indicator block separation

      Set the indicator block to be unseparated, separated by line separator, or separated by background fill.

      Line separator color

      Set the color of the line separator of the indicator block.

      Note

      This option needs to be configured only when the indicator block separation is selected as line separator.

      Background color

      Set the background fill color of the indicator block. Supports two methods: monochrome and multicolor. Monochrome supports selecting colors, and multicolor supports colors following the changes of trend chart elements.

      42.gif

      Note

      This option needs to be configured only when the indicator block separation is selected as background fill.

      Indicator block spacing

      Set the spacing of the indicator block.

      Note

      This option needs to be configured only when the indicator block separation is selected as background fill.

  • Within the indicator content configuration, you can specify the content's position, display method, font size, style, and the style of the indicator's decorative chart for the indicator block.

    image.png

    Chart configuration items

    Configuration item description

    Content position in the indicator block

    Set the display position of the content in the indicator block. Supports two methods: align left horizontally and align center horizontally. In the align center horizontally method, set the alignment with the indicator, supporting align left and align center.

    43.gif

    Indicator value line spacing

    Supports two methods: moderate and compact.

    Field description icon

    Supports using materials and setting the color of the field description.

    image.png

    Font size setting

    Select whether to enable font size setting. After enabling, you can set the font size, color, bold, italic of the dimension Name, Main Indicator Name, Main Indicator Value, Secondary Indicator Name And Secondary Indicator Value.

    Note
    • In the Indicator/measure area, the first measure item is the main indicator. The rest measures are secondary metrics.

    Indicator decoration chart

    Select whether to display the main indicator decoration chart. After selecting display, you can set the position, color scheme, decoration chart type, graphic style of the decoration chart.

    • Decoration chart position supports two methods: left and top.

      image..png

    • Decoration chart type supports two methods: material and image field.

      1. Only when the dataset contains an image field, and the field type is image type (2), can the Image Field be used. For more information.

      2. When selecting material, supports using material icons and custom uploading local images.

        Note

        Only PNG, JPG, and GIF formats are supported, with a maximum of 1M.

        指标图-静态

    • Graphic form supports two methods: transparent and solid color.

  • In the axis section, style the X-axis and the left/right Y-axis.

    9021.png

    Name

    Configuration item

    Description

    Display secondary Y-axis

    Set whether to display the secondary Y-axis.

    X-axis

    Display X-axis

    Set whether to display the X-axis.

    Display title and unit

    Set whether to display the Axis Title and Unit on the X-axis.

    Display axis labels

    Set whether to display labels on the X-axis.

    Display scale line

    Set whether to display scale lines on the X-axis.

    Display axis

    Set the display style of the axis, including line type, line width, and color.

    Display gridline

    Set whether to display gridlines on the X-axis, including line type, line width, and color.

    Left Y-axis

    Display left Y-axis

    Set whether to display the left Y-axis.

    Y-axis scale flip

    You can set to flip the Y-axis scale values.

    Untitled.gif

    Display Title And Unit

    Set whether to display the Axis Title and Unit.

    Display axis labels

    Set whether to display labels on the left Y-axis.

    Display scale line

    Set whether to display scale lines on the left Y-axis.

    Maximum value, minimum value

    • Only when the trend chart type is display trend chart, supports configuring maximum and minimum values.

    • Only when the custom maximum value is greater than the maximum value of the data itself and the minimum value is less than the minimum value of the data itself, the custom extreme value is available. Otherwise, it does not take effect.

    Note

    Select automatic to indicate that the extreme value of the axis is displayed intelligently. After clearing automatic, you can manually set the extreme value of the axis.

    Display axis

    Set whether to display the left Y-axis, including line type, line width, and color.

    Axis label display format setting

    Set the display format of the axis labels. Supports automatic adaptation, custom format, and manual input.

    When you configure a measurement unit for an indicator, you want the corresponding vertical axis label to have the same unit format when displaying the indicator. You can choose to set the display format to automatic adaptation and check the follow measure data format when single selection configuration item.

    轴标签

    Display gridline

    Set whether to display gridlines on the left Y-axis, including line type, line width, and color.

    Axis value range and interval

    • Supports automatic and manual setting of the maximum/minimum value of the left Y-axis label and scale range.

    • Supports setting custom interval by step size or by equal division quantity.

    96.gif

    Note

    Configure the right Y-axis only when display secondary Y-axis is selected, with settings similar to the left Y-axis.

  • Set the label display style in the data label configuration section.

    image..png

    Chart configuration items

    Configuration item description

    Full display

    After checking, the data labels will be fully displayed.

    Text

    Set the text style of the labels.

  • In the tooltip section, customize the tooltip content display method and the background color text style.

    image..png

    Note
    • The content supports both total and proportion only if indicator layoutindicator and trend chart interaction has multiple selection enabled. Proportion is available when displaying by a single data point, whereas both total and proportion are available when displaying by dimension value. image.png

    • The content allows for the checking of secondary indicators only if the enable secondary indicator display feature is activated. image.png

    • Switch to the mobile layout to control the display of tooltips on mobile devices. image.png

  • In the series settings, select the indicator series to configure data labels, extreme values, and data prefixes and suffixes.

    image..png

    Chart configuration items

    Configuration item description

    Please Select A Field

    Set the measure items added to the Indicator/measure area.

    Line style

    Set the line type and thickness of the lines.

    Note

    Only when the visualization chart type is line chart or area chart, configuration is supported. image

    Display data labels

    Select whether to display data labels and set the color and position of the labels.

    Display extreme values

    Set whether to display labels for the maximum and minimum values on the chart.

    Indicator Data Value Prefixes And Suffixes

    Set the prefixes and suffixes for the indicator data values on the chart.

  • Use Conditional Formatting to apply conditional formatting to the measure data.

    image

    Chart configuration items

    Configuration item description

    Please Select A Field

    Select the measure field that needs to be configured with conditional formatting. All measure items added to the Indicator/measure area can be selected.

    After completing the style configuration, if you no longer need to use certain configured conditional formats, you can also click the batch clear format operation in the lower right corner of the field panel, select the conditional formats to be cleared in the candidate list, and click OK to complete the format clearing. image

    Quick Style

    Set the marker icon or font display color of the current measure field from the styles provided by the system. image

    • Comparison: Supports selecting compare with 0, compare with average. 112

    • Color flip: Take compare 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. 112

    • Clear: When you no longer need to use a set quick style, click clear to remove the style. 112

    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.

    • TextimageIn the text tab, set the condition rules for displaying the text of the current measure field as a highlight color. Supports configuring the condition rules of the current field based on the values of other fields.

    • IconimageIn the icon tab, set the icon marking rules of the current measure field. Supports configuring the marking rules of the current field based on the values of other fields.

    Sync Style To

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

  • In the auxiliary display section, enable indicator filtering display and configure the indicator trend chart.

    Auxiliary Display Configuration

Chart Analysis Configuration

Configuration item

Name

Description

Data interaction

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 more information, see filter interaction.

Jump

If the data that you want to analyze belongs to different dashboards, you can configure this parameter to associate the dashboards, and then analyze the data. Jump includes two methods: Parameter Jump and External Link. For more information, see jump.

Advanced settings

Enable Secondary Indicator Display

Select this option to set the display form of the secondary indicator. For more information, see enable secondary indicator display.

After you enable secondary indicator display, you can specify the content, display formats, prefixes, and suffixes of secondary metrics. For example:

  • Allow customizing the number of decimal places.

    image..png

  • Supports comparison with the same period. When a filter condition is configured, the comparison with the same period will also include the filter.

    image..png

  • Supports setting the secondary indicator position below the main indicator or in a separate block.

    44.gif

  • Supports setting the font style of the secondary indicator.

    image.png

Analysis Alert

Auxiliary Line

An auxiliary line can be used to show the difference between the value of a measure and the reference value indicated by the auxiliary line. The reference value can be a fixed value or a calculated value. You can use the following calculated values: average, maximum, minimum, and median. For more information, see auxiliary line.

Label

-

If data in a chart is abnormal or requires additional attention, you can highlight the data or add icons, notes, or data points. This helps you detect exceptions and perform subsequent operations. For more information, see label.

Limits

An indicator trend chart is composed of Indicator/Measure and Date/Dimension:

  • The date is defined by the data's dimension, with only one dimension selectable, such as the order date (day).

  • The value indicators are determined by the data's measures, with at least one measure required, such as order quantity and order amount.

What to Do next

  • To allow others to view the dashboard, share it with specific individuals. For more information, see share a dashboard.

  • To create a complex dashboard with a navigation menu for thematic analysis, integrate the dashboard into the BI portal. For more information, see create a PC data portal.