Pass filter values through drilldown mapping
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.