This topic introduces scatter charts, including an overview and an application example. This topic also describes how to configure the style of a scatter chart and how to delete a scatter chart.
Scatter charts show data correlation and distribution. A scatter chart takes one variable as the x-axis and the other variable as the y-axis, and represents the general trend of the dependent variable (y) that changes in respect to the independent variable (x). Scatter charts can also show data distribution from category and color.
A scatter chart consists of a y-axis, an x-axis, a category, and colors. The y-axis is determined by a measure. The x-axis is determined by a dimension or measure. The category is determined by a dimension. Colors are determined by a dimension or measure.
- You can specify only one dimension or measure for the y-axis, x-axis, category, and colors.
- You can specify the same dimension or measure for colors as that for the x-axis, y-axis, or category.
Scenario: Compare the unit prices and order quantities of different products in different regions. The following example uses the company_sales_record dataset to describe the application of a scatter chart.
- Log on to the Quick BI console.
- Click the Workspace tab. In the left-side navigation pane, click Datasets.
- On the Datasets page that appears, find the company_sales_record dataset and click the icon in the Actions column.
Note If you are using Quick BI Enterprise Standard, select Standard or Full Screen as the dashboard type. In this example, Standard is selected.
- Click the icon. A scatter chart appears in the display area of the dashboard.
- Click the Data tab and select the required measures and dimensions.
- Click Update. The chart is updated.
- Click the Style tab, and configure parameters in the Basic Information, Chart Type, Axes, Functionality, and Series Settings sections.
- Click the Advanced tab, and configure parameters in the Advanced Settings and Metric Analysis sections. The Trendline and Clustering functions are available only when a measure
is specified for the x-axis.For more information, see Drilling, filter interaction, and hyperlink and Metric analysis.
Note After the Clustering function is enabled, the value of the Color field changes to Clustering, and data points with similar x values and y values are displayed in a cluster.
- Click Save in the upper-right corner. In the Save Dashboard dialog box that appears, enter a name for the dashboard and click OK.
Configure parameters on the Style tab
- In the Basic Information section, configure Show Title and Description, Show Link, and Custom Background.
Note If you want the user to be redirected to a report or an external page, select Show Link and specify Link Text and Link Address.
- In the Chart Type section, configure Show Labels, Show Legend, and Data Point Color.
Note The colors of data points vary based on the data type of the Color field. If the Color field is not specified, the Data Point Color field does not appear. When the Color field is set to a dimension, you can select a color palette or specify a color for each field. When the Color field is set to a measure, you must specify the value range of the measure and the number of intervals, and then specify colors for the intervals.
- In the Axes section, configure basic information about the x-axis and y-axis.
- In the Functionality section, enable the four-quadrant function as required.
Note This function can be enabled only when measures are specified for the x-axis and y-axis.
- In the Series Settings section, configure Display Name and Number Formatting for each measure. When Number Formatting is set to Customer, configure the data format (Number or Percentage) and the number of decimal places.
Delete a chart
Perform the following steps to delete a chart:
- Click the icon in the upper-right corner of a chart.
- Select Delete.