This topic describes how to configure a chart. You can configure parameters on the Data, Style, and Advanced tabs.

In the Chart Design pane of the dashboard editing page, you can add dimension or measure fields for a chart, and configure parameters on the Style and Advanced tabs.
Note Parameters that can be configured on the Data, Style, and Advanced tabs may vary based on data sources and chart types. You can configure these parameters based on actual scenarios.
  • Configure parameters on the Data tab
  • Configure parameters on the Style tab

    On the Style tab, you can change the style of a chart. Parameters that can be configured on the Style tab vary based on chart types. The following parameters are configured in a line chart:

    • In the Basic Information section, configure the title, title color, background color, hyperlink, and chart type.
    • In the Chart Style section, specify the label display mode, legend position, whether to show dual y-axis, and whether to use the stacked or 100% stacked mode.
    • In the Axes section, specify the axis title, unit, type, width, axis color, and whether to show gridlines and scales.
    • In the Functionality section, specify whether to show the scroll bar and the display mode.
    • In the Series Settings section, specify the display name, whether to show labels, the label shape, whether to display the maximum and minimum values, and the data format for a measure or dimension field.
  • Configure parameters on the Advanced tab

    Parameters that can be configured on the Advanced tab vary based on chart types. The following parameters are configured in a line chart.

    • In the Advanced Settings section, configure the auto-refresh period, filter interaction, and hyperlink. For more information, see Drilling, filter interaction, and hyperlink.
    • In the Metric Analysis section, configure Auxiliary Line, Trendline, and Fluctuation Analysis. For more information, see Metric analysis.

Configure a measure field

This example shows how to configure the order_number field.
  1. Move the pointer over the order_number field and click the 1 icon. 1
  2. Configure the following parameters based on your business requirements:
    • Aggregation Methods: SUM, AVG, COUNT, COUNT DISTINCT, MAX, MIN, Median, Percentile, Population Standard Deviation, Sample Standard Deviation, Population Variance, and Sample Variance.
      The following table describes the aggregation methods supported by different data sources.
      Data source Aggregation method
      All data sources that can connect to Quick BI SUM, AVG, COUNT, COUNT DISTINCT, MAX, and MIN
      MySQL, Vertica, SAP IQ (Sybase IQ), SQL Server, Presto, PPAS, PostgreSQL, Oracle, MaxCompute, Hive, SAP HANA, AnalyticDB for PostgreSQL, GBase, IBM DB2 LUW, Clivia, ClickHouse, and AnalyticDB for MySQL V2.0 Population Standard Deviation, Sample Standard Deviation, Population Variance, and Sample Variance
      Hbase Population Standard Deviation
      SAP IQ (Sybase IQ), Oracle, MaxCompute, SAP HANA, IBM DB2 LUW, Presto, HBase, AnalyticDB for PostgreSQL, and PostgreSQL Median
      SAP IQ (Sybase IQ), Oracle, MaxCompute, SAP HANA, IBM DB2 LUW, and ClickHouse Percentile
    • Comparison: Valid values vary based on the dimension fields. For more information about how to configure the comparison feature, see Configure the comparison feature.
    • Advanced Calculation
      • Cumulative Calculation: calculates the sum of data from the initial date to the current date. For more information about how to configure Cumulative Calculation, see Cumulative calculation.
        Note
        • You cannot configure the Comparison feature for measure fields.
        • Cumulative Calculation is supported only for fields marked with SUM (SUM).
        • Cumulative Calculation is supported if the dimension field contains only one date field and its time granularity is year, quarter, month, week, or day.
      • Percentage
        • % of Grand Total
        • % of Column Grand Total
        • % of Row Grand Total
        • % of Parent Column Grand Total
        • % of Parent Row Grand Total

        Percentage is supported only in cross tables. For more information, see Latest cross table.

      • Ranking
        • Ascend
        • Descend
        • None
        Ranking is supported in ranking boards and cross tables. For more information, see Data ranking.
      • None
    • Data Display Format
      • automatic
      • Integer
      • 1 Decimal Place
      • 2 Decimal Places
      • 1 Decimal Place (Percentage)
      • 2 Decimal Places (Percentage)
      • Custom
    • Rename
    • Sort
      • Unsort
      • Ascend
      • Descend
  3. Delete the measure field.

    Move the pointer over the field and click the 1 icon.

Configure a dimension field

This example shows how to configure the product_type field.
  1. Move the pointer over the product_type field and click the 2 icon. 2
  2. Configure the Sort parameter based on your business requirements. Valid values:
    • Unsort
    • Ascend
    • Descend
    • Custom
  3. Drill down the dimension field.

    Move the pointer over the field and click the 3 icon.

  4. Delete the dimension field.

    Move the pointer over the field and click the 2 icon.

Edit a dataset

  1. On the Data tab in the Chart Design pane, click the 1 icon.
  2. On the dataset editing page, edit the dimension and measure fields.

    For more information, see Edit dimensions and Edit a measure.

  3. Click Save.

Refresh a dataset

If data on the Data tab is not updated after you edit and save a dataset, you can perform the following operations to update the data:

On the Data tab in the Chart Design pane, click the 1 icon.

Wait a few seconds to check whether the dimension or measure field is updated.

If data is not updated, you must edit the dataset again. For more information, see Edit a dataset.

Configure multiple measure fields

Perform the following steps to configure multiple measure fields in the created chart at a time.
  1. On the Data tab in the Chart Design pane, click the 1 icon.
  2. In the Batch Field Settings dialog box, configure Display Name, Description, Aggregation method, and Value Display Format.
    Note Parameters in the Batch Field Settings dialog box vary based on chart types. You can configure these parameters based on actual scenarios.
    You can also perform the following operations to configure Aggregation method and Value Display Format for multiple measure fields at a time:
    • Select multiple fields and specify Aggregation method and Value Display Format next to Batch Settings.
    • Select Select All and specify Aggregation method and Value Display Format next to Batch Settings.
  3. Click OK.