Drill Down and Drill Up Data Discovery

The following conditions apply to Drill Down/Up functionality:

To use this feature, here is 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

Drill Down

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:

  • Level 1: un_region = 'Americas'
  • Level 2: un_subregion = 'South America'
  • Level 3: country.

Note that every time you move down a hierarchy level, the scale of the vertical axis adjusts automatically.

navigating down the hierarchy
Drilling Down the Dimensional Hierarchy Levels

Drill Up

To use Drill Up, place the pointer over the label of the horizontal axis itself, and note that it change color; it is also link-enabled. Click the horizontal axis label to go up the hierarchy levels.

In the following graphic, we moved up along these levels:

  • Level 3: country where un_region = 'America' and un_subregion = 'South America'
  • Level 2: un_subregion = 'South America' where un_region = 'America'
  • Level 1: un_region.

Note that every time you move up a hierarchy level, the scale of the vertical axis adjusts automatically.

navigating up the hierarchy
Moving Up the Dimensional Hierarchy Levels