1. Home
  2. Knowledge Base
  3. Ad Hoc Views - Charts
  4. Ad Hoc View – Stacked Column Spline Chart

Ad Hoc View – Stacked Column Spline Chart

Stacked Column Spline charts display left most measures as stacked columns, with the last measure displayed as data points connected by a fitted curve.

Dual-Axis charts allow you to compare two or more measures, using multiple charting types.

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


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

Step 2. Click on the Select Visualisation Type icon in the top menu

Visualisation Type Icon

The Select Visualisation Type window is displayed

Step 3. Select Dual and Multi-axis from the list

There are four Dual-Axis charts available:

Each chart type displays your data in slightly different ways.

Step 4. Select Stacked Column Spline Chart

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

Tip: for the data to be meaningful, the measures should be on the same scale, e.g. hours, $, count of attendances, number of clients.

Available measures

e.g. Direct Hours, Indirect Hours, Travel Time (this will indicate the total time invested in sessions as a stacked column), Count of Financial Counselling (this will show the number of sessions)

Stacked Column Line

With 4 measures and no fields, the chart displays the stacked column for the first (left-most) measures and a point for the last (right) measure.

Step 6. Click and Drag a field to the rows area

e.g. Primary Address City.

This allows the measure data to be broken up by the field information.

Add field to row

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

Field added no change to chart

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

Data Level

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 slider all the way to the right.

Tip: If you hover your mouse over the left and right ends of the slider the data level options will be displayed.  Sometimes there are multiple options along the length of the slider.

 Stacked Column Spline chart

 The measure is now broken up by the added field.

Step 7. To break the measure further, add another field to the rows section.

e.g. Gender

Add another field to rows

Again, the chart does not change as the slider begins at the totals (far left) end.

Step 8. Slide the rows slider to the right.

Stacked Column Spline

Note – to make the chart clearer, we have added a filter to only show a subset of data. For more information on Filters, refer to Ad Hoc View – Filters

The measures are now split by the additional row field (Gender) but grouped by the row field (Primary address city).

If you change the order of these rows, the chart will group by Gender and split by 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.

Step 9. Hover your mouse over a data point to display the detail of the measures.

Stacked Column Spline data

Further Information

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

Updated on May 1, 2020

Related Articles