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

Prerequisites

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

Overview

A scatter chart consists of x-axis and y-axis variables. Scatter charts show the correlation and distribution of data. In the scatter chart, the y-axis variable changes in relation to the x-axis variable. The scatter chart shows the overall trend of your data. You can configure the color dimension and category dimension to visualize data distribution.

When you create a scatter chart, you must specify Y axis (Mea.), X axis (Dim. or Mea.), Category (Dim.), Color (Dim. or Mea.), and Playback Timeline/Time Dimension.
  • You can specify only one measure for Y axis (Mea.).
  • You can specify only one measure or one dimension for X axis (Dim. or Mea.).
  • You can specify only one dimension for Category (Dim.).
  • You can specify only one measure or one dimension for Color (Dim. or Mea.).

    Color (Dim. or Mea.) can share the same dimension or measure with Y axis (Mea.), X axis (Dim. or Mea.), or Category (Dim.).

  • You can specify one dimension for Playback Timeline/Time Dimension. The dimension must be a date field.
    Note Playback Timeline/Time Dimension can be enabled only when you specify measures for both Y axis (Mea.) and X axis (Dim. or Mea.).

Example

The following example shows how to use a scatter chart. 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 Division of square paper icon in the top menu bar and click the Scatter Chart icon. Scatter chart
  4. On the Data tab, select dimensions and measures based on your business requirements.
    • In the Measures list, double-click price. You can also drag this measure to the Y axis (Mea.) field.
    • In the Measures list, double-click order_number. You can also drag this measure to the X axis (Dim. or Mea.) field.
    • In the Dimensions list, double-click area. You can also drag this dimension to the Category (Dim.) and Color (Dim. or Mea.) fields.
    • In the Dimensions list, double-click report_date(year). You can also drag this dimension to the Playback Timeline/Time Dimension field.
  5. Click Update to update the scatter chart. Effect diagram - 3.11
    • You can click the 1 icon next to Y axis (Mea.) on the Data tab to modify the display name, aggregation method, and value display format of a measure. For details, see Configure a chart.
    • You can click the 1 icon in the scatter chart to display data in different years.
  6. On the Style tab, configure parameters in the Basic Information, Chart Style, Axes, Functionality, and Series Settings sections.

    For more information, see Configure scatter 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 scatter chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the scatter chart every 5 minutes.
    Filter Interaction After you configure Filter Interaction and click an area or field in the scatter chart, data in other charts that are associated with this chart is updated. For more information, see Configure the filter interaction feature. Example - 3.11
    Hyperlink After you configure Hyperlink, you are directed to the linked report when you click a field in the scatter 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 types of trendlines: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Metric analysis.
    Note Trendlines are supported only when Playback Timeline/Time Dimension is not used.
    Label - Labels are used to mark the values of a specific dimension in the scatter chart. For more information, see Label.
    Note Labels are supported only when Playback Timeline/Time Dimension is not used.
    Scatter chart - 3.12
  8. Click Save in the upper-right corner of the page to save the settings.

Configure scatter chart styles

  • In the Basic Information section, configure Show Title and Description 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 scatter chart, you are redirected to the linked report or an external link.
  • In the Chart Style section, configure Show Chart Labels, Show Legend, Data Point Color, and Data Point Size. Chart style
    Data Point Color is available only when Color (Dim. or Mea.) is specified on the Data tab.
    • If you specify a dimension for Color (Dim. or Mea.), you can select a color series or set colors for different field values.
    • If you specify a measure for Color (Dim. or Mea.), configure the value range and intervals for the measure before you set colors for different intervals. Chart style
  • In the Axes section, configure axis styles.
    Parameter Option Description
    X-Axis Axis Title The title for the x-axis.
    Unit The unit for the x-axis.
    Minimum and Maximum The maximum and minimum values on the x-axis.
    Note If you select Default, the minimum and maximum values are automatically displayed on the x-axis. If you clear Default, you must manually configure the minimum and maximum values on the x-axis.
    Auto Magnify Value Differences Specifies whether to magnify the value differences on the x-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 x-axis.
    Show Axis Specifies whether to show the x-axis, including the line style, line width, and color.
    Y-axis Label Settings The display format of the x-axis. Options: AutoFit, Custom, and Manual.
    Show Value Specifies whether to show label values on the x-axis. Show Value - 3.11
    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 Axis Title The title for the left y-axis.
    Unit The unit for the left y-axis.
    Minimum and Maximum Specifies whether to show the minimum and maximum values on the left y-axis.
    Note If you select Default, the minimum and maximum values are automatically displayed on the left y-axis. If you clear Default, you must manually configure the minimum and maximum values on the left y-axis.
    Auto Magnify Value Differences Specifies whether to magnify the value differences on the left y-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 left y-axis.
    Show Axis Specifies whether to show the left y-axis, including the line style, line width, and color.
    Y-axis Label Settings The display formats for labels on the left y-axis. Options: AutoFit, Custom, and Manual.
    Show Value Specifies whether to show label values on the left y-axis.
    Gridlines Specifies whether to show gridlines on the left y-axis, including the line style, line width, and color.
    Show Scale Specifies whether to show scales on the left y-axis.
    Note If you select Dual Y-Axis in the Chart Style section, the Right Y-Axis tab appears. For more information about how to configure parameters on this tab, see the description of the Left Y-Axis.
  • In the Functionality section, select Enable Four-quadrant and configure the displayed parameters. Enable Four-quadrant - 3.12
    Note You can enable the four-quadrant feature only when both Y axis (Mea.) and X axis (Dim. or Mea.) are configured with measures.
    When you configure Playback Timeline Settings, take note of the following items:
    • If you select Auto Playback When Page Loads, the animation of the scatter chart is automatically played after the page is loaded.
    • If you select Loop, the animation of the scatter chart is played repeatedly.

      You can click the 1 icon to stop the playback.

    • If you select Show Current Time, time is displayed during the playback. 1
  • In the Series Settings section, configure Series and Display Name.
The following figure shows the updated scatter chart. Example - 3.11