See All Videos

How Data Studio Can Drill Down in a Table

By Brett
September 10, 2020

Table drill-downs in Data Studio allow you to explore hierarchies in data in a single table. In this video, we will show you how to use the drill-down function in a table, plus how to create a drill-down in the Data Studio editor.

View Transcript

Drill downs in Data Studio allow you to explore hierarchies in data, specifically of dimensions. So over here we had medium, and then underneath that you could actually see source status. Or here we have referral, and then you have the individual sources. You can also use it to explore date hierarchies like month, year, day, or in this case we have month. And then we could also explore down and explore all of the data and explore individual days of the week.

To create these, you would just go into your actual table after you create it. You add your primary dimension, and then you add your sub dimensions that you want to break into, that hierarchy down in more detail. You’d turn this drill down on, and then you’d choose your default drill down which will show at once. You can only have one dimension showing at any one time, and as many metrics as you like.

If you would like to learn more about analytics for Data Studio, Google Analytics or BigQuery, please subscribe to our channel. Thank you.

Still need help?

About the Author
Brett uses analytics to help clients put all the pieces together—from identifying KPIs to finding the right data to measure those KPIs and then collecting that data. He’s been in digital marketing for 8+ years and brings analytics leadership to the Anvil team. If he’s not drilling into data, he’s probably hanging with his kids or maybe playing some D&D.
More from this author
Ready to start a project?
let's work together