Arcadia Enterprise supports measures in the trellis, for comparing multiple measures at the same time. This feature works in bar, line, area, and grouped bar visual types.
To implement this feature, simply add all the required measurement fields to the trellising shelves of the visual.
Follow these steps to create a multi-measure representation of data in the World Life
Expectancy
dataset.
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 Axis shelf. Specify ascending order, and alias the field as
'Year'.gdp_per_capita
and
place it on the Y Axis shelf. life_expectancy
and
place it on the Y Axis shelf. population
and place it
on the Y Axis shelf.un_region
and place it
on the Colors shelf. Alias the field as 'UN Region'.Change the calculations and alias for each of the fields on the Y Axis using the Expression Editor:
Change gdp_per_capita
to the following expression, and click
Validate & Save.
sum([gdp_per_capita] * [population]) / sum([population]) as 'GDP per Capita'
Change life_expectancy
to the following expression, and click
Validate & Save.
sum([life_expectancy] * [population])/sum([population]) as 'Life Expectancy'
Change population
to the following expression, and click
Validate & Save.
sum([population]) as 'Population'
Click Refresh Visual.
The trellised line visual appears. Notice that this approach makes it easy to see the values of all measurements along the same horizontal dimension (in this case, year).