It is often enlightening to see related dimensions on the same line chart; it clearly shows both correlation and pattern. However, values may be measuring completely different things, or the range of values (scale) is too different to show both lines clearly. Arcadia Enterprise offers a dual axis option for situations like these.
The following steps demonstrate how to create a line visual that uses a double axis; it is based on dataset World Life Expectancy
[data source samples.world_life_expectancy
].
World Life Expectancy
[data source samples.world_life_expectancy
]; see Creating Visuals.Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
year
and place it on the X shelf.life_expectancy
and place it on the Y shelf.population
and place it on the Colors shelf.Change the aggregate of the life_expectancy
field from
sum(life_expectancy)
to avg(life_expectancy)
:
On the shelf of the visual, click the icon to the right of the field.
In the Column Properties menu, click the icon next to Aggregates.
From the list of aggregate functions, select Average.
Click icon at the top of the Column Properties menu to close it.
Note that the shelf now contains the modified field with avg()
aggregation
function.
Click Refresh Visual.
The line visual appears.
It is impossible to see the values on the life expectancy line because the population line sets the scale for the Y axis. In fact, the label does not correspond to the scale shown.
On the Colors shelf, on sum(population)
field, click the icon (down arrow), select Axis, and then select Secondary Axis.
The two lines can now be seen clearly.
Notice that there is now a Y axis both on the left and the right side of the visual.
For convenience, the color of the axis labels match the line.
World Population - Lines, Dual Axis
.