Starting with ArcViz Release 3.2, we provide an alternate solution for hierarchical dimension representation in cross tabulation visuals.
The following steps demonstrate how to create and configure a de facto dimensional
hierarchy on the shelves of a cross tabulation visual. We are using dataset World Life
Expectancy
[data source samples.world_life_expectancy
], to build a
cross tabulation table that can switch between representations at three different levels of
data granularity.
Start a new cross tabulation visual on the World Life Expectancy dataset.
See Cross Tabulation.
Populate the shelves of the visual:
un_region
and drag it over Y shelf on the main part of the screen. Drop to add it to the shelf. Repeat with un_subregion
and country
, adding them to the right of un_region
. Note that your placement of these fields is from the greatest to the smallest area, left to right.population
and drag it over Measures shelf on the main part of the screen. Drop to add it to the shelf.On the Y shelf, on the un_region
field, click the (down arrow) icon, select Expansion, and then select Enable Expansion.
Similarly, on the Y shelf, on the un_subregion
field, click the (down arrow) icon, select Expansion, and then select Enable Expansion.
Click Refresh Visual.
The cross tabulation table appears.
To see more detail, expand the un_region
column of the visual by clicking the (plus) icon below the column header.
Similarly, expand the un_subregion
column of the visual by clicking the (plus) icon in the field next to one of the un_regions
. We chose to expand Asia.
Finally, expand the country
column of the visual by clicking the (plus) icon in the field next to one of the un_subregions
. We chose to expand Central Asia.
Change the title to Hierarchical Cross Tabulation of Population
.
At the top left corner of the Visual Designer, click Save.
Switch to View mode to examine the operation of the dimensional hierarchy.
un_subregion
column of the visual by clicking the (plus) icon below the column header, it generates a complete tabulation aggregated by un_subregion
.
country
column of the visual by clicking the (plus) icon below the column header, it generates a complete list by country
.