Hey everyone, I have a feeling this can be done since .36 but I am having a hard time figuring it out.
We have a dashboard with several questions on it, but only one question needs to have this Time Series/Period over Period layer comparison. So once the user selects from the Date Filter, we want to compare the selected time-frame that was chosen, for instance here is over several months AND days.
How can we have the time series line chart visualize the previous period with the current date filter selected. Something similar to:
select count(*) from “my_table” where “my_date” > (current_date - interval ‘2 week’) and “my_second_date” < (current_date - interval ‘2 week’);
It would be ideal if this could be done at an expression level using the built in builder, rather than using SQL as we would be able to spin these reports up faster. If not, how can it translated into metabase?