Page Comparison

A Bubble chart uses color-coded circles ('bubbles') plotted on an x X and y Y-axis to represent measures. The  By default, the first measure will be the x axis, displays on the X-axis and the second measure is displays on the y axis and the Y-axis. The third measure (, if there is one) , determines the size of the bubblebubbles. You can choose which measure is X-axis or Y-axis and set swap the measures around to change what displays on each axis and change the bubble size.

The In summary view, the chart displays a bubble for each focused item in the selected dimension. In summary time unit (month/day/year) in the period, as illustrated in example 2 below.

In a focused view, the chart displays a bubble for each time unit (e.g. month). 

focused item, as illustrated in example 1 below.

Example 1 - Compare the margin and value of selected product classes

In the Sales database, create a Bubble chart to visualize the high-margin low-value products, and vice versa. Specifically,

you want to

chart the Value,

Value/Item and Margin measures for items in the

Product sub class

dimension. 

1. Prepare the data in the grid:

   1. Select the Product Sub Class dimension, then select and focus on a number of sub-classes

1. 1. .

1. 2. Select Mode > Total.

   3. Specify the first two measures: Select Measures > Local value and Local Value/Item.

2. Click the Chart button in the top right toolbar above the grid.

3. Click the Bubble chart category button on the left of the chart and select the Bubble option. The chart displays and all bubbles are the same size. 

1. Image Added

2. Add a third measure

1. : From the chart view, select Measure > Reporting Margin %

1. . The Reporting Margin % is now available in the Radius Values setting. If it is not automatically selected for you, select it from the list (see image below).

   Image Added

The bubbles in the chart change size and an extra legend appears on the bottom right to display the relationship between Margin and the bubble size. In this example, you can see that highest value group (Downlights) has a relatively low margin (small circle). The group causing concern is Outside, which has low sales, low value per item and low margin group.

Image Modified

Example 2 - Compare the total performance of product classes

Using the Bubble chart in

the above example, click the Summary button. The chart updates to display a bubble for each time unit within the selected period

, which in this case

is Financial YTD

and each bubble displays the total performance of the selected product classes for each month

so far.

Image Modified