Let viewers drill down into your data
Turn on drill-down to explore data hierarchies.
Last updated
Turn on drill-down to explore data hierarchies.
Last updated
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.
Edit your report.
Select a chart.
On the right, in the DATA properties panel under Dimension, turn on Drill down.
Add dimensions to the chart. Each dimension you add becomes another level of detail you can drill into.
Select the Default drill down level.
Legend:
Add dimensions.
Turn on drill down. (Note: you need to turn this on before you can add drill-down dimensions.)
Set the default drill-down level.
To add drill-down capability to a chart, you'll define a dimension hierarchy. The hierarchy defines the levels of detail 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 within the hierarchy matters. As a rule of thumb, you should define hierarchies to always go from the most general to the most 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
View your report
Choose a chart in which you've turned on 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, click on up or down arrow to see details.
This displays all the cities, regardless of which country they are in.
To turn off drill-down:
Edit your report.
Select the chart.
On the right, in the DATA properties panel, turn off Drill down.
You can see additional levels of detail in a pivot table by turning on expand-collapse. You can then show or hide the data from the dimension hierarchy in the pivot table by clicking + and – in the column header. Learn more about pivot tables.
Drill-down doesn't apply to dimensionless charts, such as scorecards and bullet charts.
Geo charts don’t support all geographic field types within all zoom areas. See the Geo chart reference for more details.
Click the up and down arrows to see details
