Bubble chart

The bubble chart uses three or four data dimensions, or variables, to show the relation between the individual data points associated with one or more categories. Categories are non-quantitative data elements such as customers, vendors, departments, branches, merchant category codes, transaction types, statuses, and so on. A single, quantitative category can also be plotted using a bubble chart.

A quantitative data dimension determines the size of the data points associated with a category, which allows for comparisons based on the size of data points in addition to their position.

The bubble chart in Figure 1 uses three data dimensions to show transaction amounts and discount, grouped by day. The bubble chart in Figure 2 uses four data dimensions to show transaction amounts and discount, grouped by day and identified by customer.

Table 1 provides additional details about bubble chart configuration settings.

Figure 1. Bubble chart with three data dimensions (Transaction Date, Amount, and Discount)

 

Figure 2. Bubble chart with four data dimensions (Transaction Date, Amount, Discount, and Customer Number)

 

Table 1. Bubble chart configuration settings

Setting

Data types supported

Example field

Description

X-Axis

(horizontal)

Datetime

Numeric

Transaction Date

Specifies the field to use as the basis for the chart’s horizontal scale.

Y-Axis

(vertical)

Datetime

Numeric

Amount

Specifies the field to use as the basis for the chart’s vertical scale.

Bubble size

(size of data points)

Numeric

Discount

Specifies the numeric field to use to determine the size of individual data points.

An increase in size indicates an increase in quantity or value.

Total (sum) is the default aggregation option. The Size field also supports average, minimum, maximum, or count aggregation options. For more information see About visualizations.

Color by

(optional setting)

Character

Customer Number

Specifies the field to use to add a fourth data dimension to the chart.

Adding a fourth data dimension identifies the data points by category. You can think of the Color by field as a break field.

The Color by setting provides the following options:

  • If you omit a Color by field, data points are not identified by category and are all the same color.

  • If you specify a Color by field, data points are identified by category, with categories differentiated by color. A category is created for each unique value in the field.

Related concepts
About visualizations
Related tasks
Creating charts


(C) 2015 ACL Services Ltd. All Rights Reserved.