Looker Community

Visual Drilling

What is Visual Drilling?

Visual drilling allows users to drill from one visualization into another visualization instead of a data table.

How does it work?

Looker will automatically select a visualization based on the data that will be returned from the drill. The selection mechanism is the same as on the Explore page. Certain types of query results won’t return a visualization, like those that have too many dimension values to plot on a chart.

How about an example?

Sure! Here we’re looking at a state-level map, and we want to drill in by zip codes. We select zip codes from the dropdown here:

screen shot 2016-09-12 at 4 54 39 pm

and then we show this map of those zip codes

In the past we would have shown a data table. You can toggle between the visualization and the data table using the buttons in the upper right of the modal.

Additionally, Explore From Here will launch the Explore page already seeded with this query.


Wow, this is fantastic! Been wanting to see this since the drill features were put in place.

@abbywest is there a way to format what visualization you see in the drill? Line vs. bar, etc.

Should have read your entire post, which says Looker chooses the viz by default. I guess–are there plans to allow for customization?

To give more control to our users, we’ve placed visual drilling under the Visual Drilling Labs feature in Looker 4.10. Now you can choose whether or not you’d like visual drilling to occur.

Any plans to make this feature GA? We’re hesitant to use Labs features widely without knowing if they are 1) stable and 2) going to persist.

Hi Brendan,

Visual drilling is a beta labs feature so it is expected to remain in the product. More on types of labs features here.

When visual drilling is turned off in labs, the drilling defaults to a table visualization as opposed to the most relevant visualization, so if you were to use it now and then decided to turn it off in the future it shouldn’t cause any issues.



Is there any way to format the table visualisation in the drill downs?


This post is all about how to customize drill downs and I’ve found it very helpful: More Powerful Data Drilling

In addition to listing the drill fields, you can also use the link parameter to add in sort order, row limits, pivots, etc. The post also explains how to make the drill down display any type of viz you specify.