Drilling into a field to get a pivot table

  • 26 March 2015
  • 2 replies

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):,orders.count,users.gender&pivots=users.gender