Quick BI:Scatter Chart

Prerequisites

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

Overview

• Scenarios

  Two sets of data are used to generate multiple points in the coordinate system. You can observe the distribution of these points to determine whether a correlation exists between variables or summarize the distribution pattern.

  Purpose: You can use a scatter chart to easily obtain the following key information:

  • Whether a quantitative correlation exists between variables.

  • Whether the correlation is linear or curved.

  • Whether outliers exist. An outlier indicates a point that deviates from most points. You can further analyze whether the outliers affect modeling analysis.

• Benefits

  • Computing capability: The conversion rate is automatically calculated.

  • Data visualization: A scatter chart can be displayed dynamically based on the timeline of data.

• Example of a line chart

Configure a scatter chart

1. In the Data pane, select dimensions and measures based on your business requirements.

   • In the measure list, double-click price. You can also drag this measure to the Y axis (Mea.) field.

   • In the measure list, double-click order_number. You can also drag this measure to the X axis (Dim. or Mea.) field.

   • In the Dimension list, double-click area. You can also drag this dimension to the Category (Dim.) and Color (Dim. or Mea.) fields.

   • In the Dimension list, double-click order_date(year). You can also drag this dimension to the Playback Timeline/Time Dimension field.

2. Click Update to update the scatter chart.

3. 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.

Configure the style of a scatter chart

• In the Basic Information section, set the following parameters.

  1. Show Title and Description

  2. Show Link

  3. Description

  4. Footer

  ⑤ Component container

  ⑥ Card spacing

  

• In the Chart Style section, set the Show Chart Labels, Show Legend, Color, and Data Point Size parameters.

  The Color parameter is displayed 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.), you must configure the Data Mapping Segments parameter before you set color for different segments.

• In the Axes section, configure the style of the axes. The following table describes the parameters.

  Parameter	Parameter	Description
  X-Axis	Axis Title	The title of the X-axis.
  	Unit	The unit of 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 need to 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 x-axis. Note If Auto Magnify Value Differences is selected, the axis range is adjusted based on the minimum and maximum values.
  	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 of the x-axis.
  	Y-axis Label Settings	The display formats for labels on the y-axis. Valid values: AutoFit, Custom, and Manual.
  	Show Value	Specifies whether to show values on the x-axis. If you select Show Value, you can specify the font type, font size, and color of values.
  	Gridlines	Specifies whether to show gridlines on the x-axis, including the line style, line width, and color of the x-axis.
  	Show Scale	Specifies whether to show scales on the X-axis.
  Left Y-axis	Axis Title	The title of the left y-axis.
  	Unit	The unit of 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 need to 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.
  	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 of the left y-axis.
  	Y-axis Label Settings	The display formats for labels on the axis. Valid values: AutoFit, Customer, and Manual.
  	Show Value	Specifies whether to show 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 of the left y-axis.
  	Show Scale	Specifies whether to show scales on the axis.
  	Label and Scale Range	You can automatically or manually set the Maximum /Minimum value of the left Y-axis label and scale range.

  Note

  If you select Dual Y-axis in the Chart Style section, you also need to configure Right Y-axis. The parameter configurations on the right y-axis are the same as those on the Left Y-axis tab.

• In the Functionality section, select Enable Four-quadrant and set the displayed parameters.

  Note

  You can enable the four-quadrant feature only when both x-axis and y-axis are specified 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.

  • If you select Show Current Time, time is displayed during the playback.

  • If you select Enable Trace Drawing, you can click a scatter point to draw its trace in the order of the playback axis.

• In the Series Settings section, configure Series and Display Name.

Configure advanced settings

Limits

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 only one dimension for Playback Timeline/Time Dimension. The dimension must be a time field.

  Note

  Playback Timeline/Time Dimension is applicable only when you specify measures for both Y axis (Mea.) and X axis (Dim. or Mea.).

What to do next

• You can share your dashboard with others. For more information, see Share a dashboard.

• If you want to create a navigation menu for thematic analysis, you can integrate your dashboard into a business intelligence (BI) portal. For more information, see Create a BI portal.