Is it possible to set up a drill down field, so that when I click on it, I get a new table that is already pivoted?
I’m imagining using this to drill into some large top-line metrics, breaking the results out into both date and regions at the same time.
To accomplish something like this, you would need to use liquid templating to pass parameters from the drilled item to a new URL. Below is an example from our demo instance to drill into two different URLs to learn about a user’s history. The same technique could be used to create any URL format you would like.
To reference a pivot, the URL structure looks like this (note the pivoted field is also included in the fields list):
https://demo.looker.com/explore/thelook/orders?fields=orders.created_date,orders.count,users.gender&pivots=users.gender
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.