Skip to main content Skip to complementary content

Drill-down groups

When several fields form a natural hierarchy, it can make sense to create a drill-down group.

Example 1:  

Organization: Company, Department, Employee

Example 2:  

Geography: Continent, Country, State, City

When you use a drill-down group as a dimension in a chart, the chart uses the first field in the group's list of fields that has more than one possible value. If the currently made selections cause the field to have only one possible value, the next field in the list is used instead, provided that it has more than one possible value. If no field in the list has more than one possible value, the last field is used anyway.

In the first example above, Company will be used as chart dimension until a single company is selected. The chart will then show Department. If a single department is selected, the chart will switch to Employee.

As selections are reverted, so that more than one value becomes possible in the upper fields of the group's field list, the chart is automatically drilled back up.


The drill-up function is available in bar charts, pie charts, and line charts. Other visualizations reflect the changes made in the charts, but cannot themselves be used to drill up through the different dimensions. When you drill down in a dimension group, breadcrumbs provide links back to the previous dimensions. Click the dimension that you want to drill up to.

In the following bar chart, the breadcrumbs Year > Quarter > Month enable drilling up.

Bar chart

Related learning:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!