I have an explore that is two views joined by id. Both views have a required time filter (to properly query a partitioned table), and both views should be filtered on the same value. I want to set this filter at the dashboard level so that it can be adjustable. How can I do this?
I know that for tiles using merged results I can use a single filter on both merged views, but on a joined explore it will only let me select one. Is there a way to select both with just one filter on the dashboard? I also can’t add it as a condition for the join because it needs to be filtered before being grouped.