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

Ad Hoc View – Area Spline Chart

Area Spline charts display data points connected with a fitted curve and a colour below the line; groups are displayed as transparent overlays.

Area charts compare values displayed as points connected by lines, with colour below the line.

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

 

Instructions

Step 1.  Open or create a new ad hoc view (refer to Creating Ad Hoc Views 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.

Chart Options

Chart Types option

Area Charts

 Area charts display data points connected with straight lines, with colour below the line.

There are four Area charts available:

Each chart type displays your data in slightly different ways.

 

Area Spline Chart

The Area Spline Chart can display data, with data points connected by a fitted curve rather than straight lines. Colour is displayed below the line and groups are displayed as transparent overlays.

Step 4. Select Chart Types and select Area Spline chart.

Area Spline Chart

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

Area Spline Hover

 

Step 5. Click and drag a measure from the measures area on the left-hand side pane to a row or column.

e.g. Income Amount

Add measure to chart

Tip: All charts must have at least one measure.

 

With a single measure and no fields, the chart displays the total for the measure.

Single measure

 

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

e.g. Primary Address City.

Add field to row

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

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.

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

Area Spline Chart

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.

The measure is now broken up by the added field.

 

Step 7. To break the measure further, all a field to the columns section.

e.g. Gender

Add additional field

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

 

Step 8. Slide the columns slider to the right.

Area Spline Chart

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 column field (Gender) but grouped by the row field (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.

Area Spline Chart

 

Further Information

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

Updated on April 19, 2018

Related Articles