Drilling through Hierarchical Data

If hierarchical dimensions are included in a chart, you can drill up or down through dimensions to explore the data at different levels.

Context

If the chart contains more than one hierarchical dimension, you can select which dimension to drill into.

Do the following to add a hierarchical dimension to a Numeric Point chart:

In the builder panel, select (Add/Remove Chart Components) Add Trellis.
In the Trellis section, select Add Dimension and then select your hierarchical dimension.

Select an area in the chart or a label on the axis.
For example, you can select one or more bars in a bar chart.

The selected area in the chart is highlighted.
Right-click and select Drill Down or Drill Up, and then select the dimension to drill on.
You can also show all levels of the hierarchy by choosing Expand/Collapse.
To remove or reset the drill option, in the title area for the chart select Reset Drill and then choose which dimension to remove.

Note

Reset Drill resets the drill level to 1, not to any other level that you may have set.