As of Looker 3.40, we have added 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
linksparameter, documented [here] (Linking to URLs in drill menus (3.40+)).
In order to drill from dimension 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 in 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 you are drilling into.
There is an element in that dashboard that has global filter applying to that 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 will the filter set to this state:
This is a great way to explore your data further through dashboards!
Other uses of drill menus
Read more about: