In Looker, we have the ability to drill from dimensions to dashboards, using hierarchical drill menus (Read more about hierarchical drilling here).
This post refers to the Labs feature, which automatically identifies potential dashboards to drill to from a given dimension. To specify links to specific dashboards (or other non-Looker URLs), you can use the
links parameter, documented here (Linking to URLs in drill menus).
To drill from dimensions to dashboards, go to Admin > Labs and enable the Dashboards in Drill Menus feature.
When Do Dashboards Appear in the Drill Menu?
Once Dashboards in Drill Menus is enabled, dashboards will automatically appear in the drill menu if they have a filter on the field you are drilling into. This happens in a couple cases:
- There is a global filter on the dashboard of type Field that points to the field into which you are drilling.
- There is an element in that dashboard with a global filter that applies to the field in that element. For example, I might have number filter that I apply to Users Age in a particular dashboard. This will allow this dashboard to appear in the drill menu for the Users Age field.
What will drilling to a dashboard do?
Let’s say I have a Business Pulse dashboard that has a global filter on Users State:
If dashboard drilling is enabled, this dashboard will appear as an option in the drill menu for the User State field like so:
When I click this dashboard, it will take me to the dashboard with the filter set to this state:
This is a great way to explore your data further through dashboards!
Read more about other uses of drill menus:
- Drilling into a row by any other dimension value.
- Linking to URLs
- Drilling in visualizations (in labs)