Pass Filter Values Through Drilldown Mapping

[intapiuser]

Drilldown Documentation

Direct Replacement Filters Documentation

When drilling down from a chart to another dashboard, we have the option to pass any of the column values as a filter value in the destination dashboard. 

However, sometimes we would like to maintain the filters already selected on the original dashboard. To do that, we'll need to select them explicitly. Below, we use the daterange filter and direct replacement syntax to do just that.

Here's an example query that achieves what we want:

select
  id
  , platform
  , created_at
  , [daterange_start] as daterange_start
  , [daterange_end] as daterange_end
from
  users
where [created_at=daterange]
limit 20

Here's how it will look on the dashboard: 

And now that we have those columns available, we can pass them via the drilldown as follows: