Let viewers drill down into your data

Enable chart drill-down to explore data hierarchies.

Drilling down gives viewers a way to reveal additional levels of detail within a chart.

For example, suppose you want to report on sessions by country, and sessions by city. Rather than include two charts in your report, you can include a single chart with drill-down enabled. When drill-down is enabled on a chart, you can

  • Drill down from a higher level of detail to a lower one (e.g., from Country to City).
  • Drill up from a lower level of detail to a higher one (e.g., from City to Country).

Adding drill-down charts to your reports can make them more interactive, reduce the number of separate charts required, and make it easier to find insights at various levels of detail in the data.

Enable drill-down for a chart

  1. Edit your report.
  2. Select a chart.
  3. On the right, in the DATA properties panel under Dimension, choose a default dimension.
  4. Turn on Hierarchy.
  5. Select the dimensions that define the levels of detail for this chart.

Legend:

  1. Enable hierarchy.
  2. Add dimensions.

How drill-down works

To add drill-down capability to a chart, you'll define a dimension hierarchy. The hierarchy determines the levels of data that chart can display when you drill down or up. Example hierarchies include:

  • Date (Year > Month > Day)
  • Geography (Country > Region > City)
  • Product (Department > Category > SKU)
  • Google Analytics events (Event Category > Event Action > Event Label)
The order in which you list the dimensions to the hierarchy matters. As a rule of thumb, you should define hierarchies to always go from the most general to the more specific. For example, defining a geographic hierarchy as Country > City > Region could produce undesirable results, because you're going from a general level to a more detailed level, then back to a more general level.

Drill down into all values

  1. View your report.
  2. Choose a chart that you've enabled for drill-down.
  3. Right-click the chart then click Drill Down.

Example: drill down to see all cities

The chart below displays sessions by country. The chart has a drill-down hierarchy defined for the Country and City dimensions. To drill down and see the sessions for all cities, right-click the chart and click Drill Down.

Screenshot

This displays all the cities, regardless of which country they are in.

Screenshot

Drill down into selected values

  1. View your report.
  2. Choose a chart that you've enabled for drill-down.
  3. Select a value (for example, Canada).
  4. Right-click the chart then click Drill Down.
  5. To drill back up, right-click the chart and click Drill Up.
To restore the chart to the default (highest) drill-down level, right-click, then select Reset action. This will also reset any filters or manual sorting you've applied to the chart.

Example: drill down to see cities in a specific country

To see only cities in Canada, select Canada in the chart, then right-click and click Drill Down.

Screenshot

You’ll now see sessions for cities in Canada.

Disable drill-down within a chart

To disable drill-down:

  1. Edit your report.
  2. Select the chart.
  3. On the right, in the DATA properties panel, turn off Hierarchy.

Limits of drill-down

  • Tables and pivot tables don’t support drill-down. However, you can simulate "drill through" behavior with this work-around.
  • Charts without dimensions (scorecard, bullet) don’t support drill-down.
  • Community visualizations don’t support drill-down.
  • Geo maps don’t support all geographic field types within all zoom areas. See the Geo map reference for more details.
Was this helpful?
How can we improve it?