Last tested: Aug 6, 2020
running_totals are post-generated after the query is run, and so when we drill, we only see the results generated for that row in the backend SQL Query rather than what we're seeing on the front end.
There is a way to create a drill though through the html/link parameter with some URL hacking!
These are the steps I followed for this workaround:
&f[order_items.returned_date]=before+2020/08/06,2020/08/06&limit...
2020/08/06
and replace em with the Liquid value of the date field we're trying to drill into on the main explore. So something like:&f[order_items.returned_date]=before+{{ order_items.returned_date._value }},{{ order_items.returned_date._value }}&limit...
link: {
label: "click me 3"
url: "/explore/andrew_ecomm/order_items?fields=order_items.id&f[order_items.returned_date]=before+{{ order_items.returned_date._value }},{{ order_items.returned_date._value }}"
}
This should allow the drill to carry over the dates as expected! Note, the only thing we may need to keep in mind is passing in existing filters into this new link!
This content is subject to limited support.