Pass filter values through drilldown mapping

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:

 

 

Voila! It works! The only downside is that your origin chart now has two extra columns that you might not want to look at.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 11 days agoLast active
  • 18Views
  • 1 Following