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.

Drill-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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?