This topic provides an overview of combination charts and an example on how to use combination charts. This topic also describes how to configure combination chart styles and how to delete a combination chart.

Prerequisites

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

Overview

A combination chart displays data series of different magnitudes by using two axes. A combination chart can be a combination of line charts, vertical bar charts, and area charts in stacked or 100% stacked mode. For example, you can use a combination chart to compare the changes of different projects.

When you create a combination chart, you must specify Primary Measures, Secondary Measures, Category Axis (Dim.), and Color Legend (Dim.).
  • You must specify at least one measure for Primary Measures and at least one measure for Secondary Measures.
  • You must specify at least one dimension for Category Axis (Dim.).
  • You can specify only one dimension for Color Legend (Dim.).
    Note Color Legend (Dim.) is applicable only when Primary Measures or Secondary Measures has one measure.
Effect diagram - 3.11

Example

The following example shows how to use a combination chart to compare the order amounts and profits across different years. 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 icon.
    Then, a combination chart is automatically displayed in the dashboard display area. Combination chart
  4. On the Data tab, configure the combination chart.
    1. Double-click the dimensions and measures you want to use, or drag them to the destination fields.
      • In the Measures list, double-click order_amt. You can also drag this measure to the Primary Measures field.
      • In the Measures list, double-click profit_amt. You can also drag this measure to the Secondary Measures field.
      • In the Dimensions list, double-click report_date (year). You can also drag this dimension to the Category Axis (Dim.) field.
    2. Change the display method of a measure.
      In this example, select Line as the chart type for profit_amt in the Secondary Measures field. Line - 3.11
      You can also move your pointer over Standard to change the stacking mode of the chart. Standard - 3.11
  5. Click Update to update the combination chart. Update - 3.11

    You can click the 1 icon next to Primary Measures or Secondary Measures to modify the display name, aggregation method, and value display format of a measure. For more information, see Configure a chart.

  6. On the Style tab, configure parameters in the Basic Information, Chart Style, Functionality, Axes, and Series Settings sections.

    For more information, see Configure combination chart styles.

  7. On the Advanced tab, configure parameters in the Advanced Settings, Metric Analysis, and Label sections.
    Parameter Option Description
    Advanced Settings Auto Refresh After you select Auto Refresh, the system refreshes the combination chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the combination chart every 5 minutes.
    Filter Interaction After you configure Filter Interaction and click an area or field in the combination chart, data in other charts that are associated with this chart is updated. For more information, see Configure the filter interaction feature.
    Hyperlink After you configure Hyperlink, you are directed to the linked report when you click a field in the combination chart. You can set Hyperlink to Parameter or External Link. If you select Parameter, you must configure global parameters. For more information, see Configure the hyperlink feature.
    Metric Analysis Auxiliary Line Auxiliary lines can be used to show the difference between the value of a measure and the reference value indicated by an auxiliary line. The reference value indicated by an auxiliary line 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.
    Trendline A trendline displays the overall trend of the data that you selected. Quick BI provides the following trendline options: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Metric analysis.
    Label - Labels are used to mark the values of a specific dimension in the combination map. For more information, see Label.
  8. Click Save in the upper-right corner of the page to save the settings.

Configure combination 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 combination chart, you are redirected to the linked report or an external link.
  • In the Chart Style section, configure the chart style based on your business requirements.
    Parameter Description
    Show Labels Options: Smart Display and Full Display.

    If a chart has a large number of measures, select Show Labels to show all the measure labels.

    Label Display Mode Options: Smart Display and Full Display.
    • If a chart has a large number of dimensions and the scroll bar is not displayed, select Smart Display to show only some data labels.
    • If a chart has a small number of dimensions or the scroll bar is not displayed, select Full Display to show all the data labels.
    Display Direction Options: Horizontal and Vertical. Display direction - 3.11
    Label Shape Options: Circle, Hollow Circle, Diamond, and Hollow Diamond. Label shapes - 3.11
    Line Style Options: Smooth and Straight.
    Note Line Style appears only when the combination chart includes a line chart.
    Show Legend The following five display modes are available. Show Legend
    Color Settings You can configure the colors for a combination chart. Colors - 3.11
    Synchronize Dual Y-Axis Scales Specifies whether to synchronize dual Y-axis scales.
  • In the Chart Style section, configure Show Labels, Line Style, Display Direction, and Show Legend.
    If a chart has a large number of measures, select Show Labels to show all the measure labels. Label Display Mode include Smart Display and Full Display.
    • If a chart has a large number of dimensions and the scroll bar is not displayed, select Smart Display to show only some data labels.
    • If a chart has a small number of dimensions or the scroll bar is not displayed, select Full Display to show all the data labels.
  • In the Functionality section, configure Show Scroll Bar, Dimension Value Sampling, and Null Value Operation. 311
  • In the Axes section, configure the axis style.
    Parameter Option Description
    X-Axis Axis Title The title for the x-axis.
    Unit The unit for the x-axis.
    Show Title and Unit Specifies whether to show the title and unit of the x-axis.
    Show Axis Specifies whether to show the x-axis, including the line style, line width, and color.
    Show Value Specifies whether to show labels on the axis.
    Gridlines Specifies whether to show gridlines on the x-axis, including the line style, line width, and color.
    Show Scale Specifies whether to show scales on the x-axis.
    Left Y-Axis and Right Y-Axis Axis Title The title for the axis.
    Unit The unit for the axis.
    Minimum and Maximum Specifies whether to show the minimum and maximum values on the axis.
    • If you select Default, the minimum and maximum values are automatically displayed on the axis.
    • If you clear Default, you need to manually configure the minimum and maximum values on the axis.
    Auto Magnify Value Differences Specifies whether to automatically magnify value differences on the axis.
    Note If Auto Magnify Value Differences is selected, the axis range is adjusted based on the minimum and maximum values of the displayed data.
    Show Title and Unit Specifies whether to show the title and unit of the axis.
    Show Axis Specifies whether to display the axis, including line style, line width, and color.
    Y-axis Label Settings The display formats for labels on the axis. Options: AutoFit, Custom, and Manual.
    Note You can also configure multiple measure display formats at the same time on the Data tab. For more information, see Configure a chart.
    Show Value Specifies whether to show the label values on the axis.
    Gridlines Specifies whether to show gridlines on the axis, including the line style, line width, and color.
    Show Scale Specifies whether to show scales on the axis.
  • In the Series Settings section, configure the required parameters.
    Note If Color Legend (Dim.) is applied, you need to configure Display Name and Number Formatting under Series Settings.
    Parameter Description
    Series You can specify a measure based on your business requirements.
    Display Name You can specify an alias for a field in the combination chart.
    Show Labels Specifies whether to show labels and label colors.
    Show Boundary Values Specifies whether to display the labels of the maximum and minimum values in the combination chart.
    Number Formatting The display format of numbers. Options: AutoFit, Customer, and Manual.
    The following figure shows the updated combination chart. Combination 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.