Ad Hoc View – Bubble Chart

  1. Home
  2. Ad Hoc Views - Charts
  3. Ad Hoc View – Bubble Chart

Bubble charts display the first measure as the x-axis, the second measure as the y-axis, and the third measure determines the size of the bubble.

 

Charts allow you to graphically display your data. There are a number of different chart types available.

Scatter and Bubble charts display the correlation between 2 or 3 measures in your data.

Instructions

 

Step 1.  Open or create a new ad hoc view (refer to the Creating Ad Hoc Views article for further information)

Step 2. Select Chart from the drop-down at the top of the screen.

Select Chart

By default, a column chart is selected.

Step 3. To change the chart type, click the options drop down in the top left corner of the chart area.

Select Chart Options

 

Step 4. Select Chart Types and select Bubble chart.

Chart Types Option

Hover your mouse over the chart thumbnail to see the chart type name.

Select Bubble Chart

 

Tip: The Bubble chart requires 3 measures in columns, with no other fields or dimensions in the columns area.
Fields may be added to rows.

 

 

Step 5. Click and drag 3 measures from the measures area on the left hand side pane to a column.

e.g. Count of Clients, Count of Community Education, Identified Attendees

Select Measures

 

As there are no row fields, only the intersection of the 3 measures is displayed.

3 measures

 

 

Step 6. To break the measure further, add fields to the columns section.

e.g. Country of Birth, Primary Address City

Fields and Measures

 

You’ll notice when the field is added that the chart may not change.

No change to chart

 

In the right-hand side pane there is a section caller Data Level.

rows slider

The slider allows you to quickly change the level at which the data is reported.  When the slider is all the way to the left, it shows the measure total.

 

Step 7. Slide the rows slider to the right.

Scatter Chart

 

 

The measures are now split by the additional column fields (Country of Birth and Primary Address City).

If you add additional fields to the rows or columns, the sliders will update and the measures will be split if you move the sliders.

You may find that the chart becomes less useful if you add too many fields.

Further Information

For further information on Ad Hoc Views and Charts, refer to the following articles:

 

Related Articles