Question

Drilling into a field to get a pivot table

  • 26 March 2015
  • 2 replies
  • 88 views

Userlevel 3

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.


2 replies

Userlevel 4

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.


Userlevel 4

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

Reply