To discover your data, you can navigate up and down the hierarchical tree.
The following conditions apply to Drill Down/Up functionality:
This feature is only available on dimensions that are part of predefined hierarchies. See Creating New Dimension Hierarchies.
These hierarchies may only be defined by users with administrative privileges, and at the level of the dataset.
Hierarchies, as implied, combine related and 'nested' dimensions of the dataset, progressing from largest to smallest measurement.
Dimensional hierarchies by their very nature do not help discover how potentially unrelated dimensions influence the results. For this, we encourage you to read the article on Drill Into Data Discovery.
To use this feature, here are examples for bar charts. We constructed them by Creating New Dimension Hierarchies, and setting up the visual World
Population - Hierarchy
, as described in Dimension Hierarchies.
To use Drill Down, place the pointer over one of the data labels along the horizontal axis, and note that it changes color; this is because the data labels are link-enabled. Click on the label to drill down to a lower level of the hierarchy.
In the following graphic, we drilled through these levels:
un_region = 'Americas'
un_subregion = 'South America'
country
Note that every time you move down a hierarchy level, the scale of the vertical axis adjusts automatically.
In the following graphic, we moved up along these levels:
country
where un_region = 'America'
and un_subregion = 'South America'
un_subregion = 'South America'
where un_region
= 'America'
un_region
Note that every time you move up a hierarchy level, the scale of the vertical axis adjusts automatically.