I am currently working on a dashboard which displays multiple “real-time” questions i.e. many of the questions are based on relative dates (last 7 days, last 6 months, current period etc.). In order to compare these questions/KPIs with previous months I would like “to go back in the past” by changing the “current date” to a previous date so that all the relative dates in the questions also change accordingly based on this new past “current date”.
Changing all the relative dates manually through individual filters which are applied to individual columns of my dataset would be too much of a hassle for the users of my dashboard as there are too many.
Is there any way how to do this in Metabase?
Many thanks in advance for your help!