Ad Hoc View – Multi-Axis Line Chart

  1. Home
  2. Ad Hoc Views - Charts
  3. Ad Hoc View – Multi-Axis Line Chart

Multi-Axis charts allow you to compare two or more measures, using multiple lines. Multi-Axis Line charts display each measure as a separate axis 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 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 Multi-Axis Line chart.

Chart Types Option

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

Multi-Axis Line Chart

There are three Multi-Axis charts available:

 

Each chart type displays your data in slightly different ways.

Multi-Axis Line charts display each measure as a separate axis line.

 

Select Multi-Axis Line Chart.

Multi-Axis Line Chart

 

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

Select a measure

e.g. Income Amount, Count of Clients

Tip: All Multi-Axis charts must have 2 or more measures.

Multi-Axis Line Chart

With 2 measures and no fields, the chart displays the total points for each 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.

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

Multi-Axis Line Chart with Row

 

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.

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.

 Multi-Axis Line 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.

Multi-Axis Line two fields

 

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 the Ad Hoc View – Filters article.

 

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.

Change order of Rows

 

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