Date Range Variable

Get Help
#1

Hi there,

I’ve question about date range variable (using “Field Filter”). I want to filter one year before the selected date.
For example, the user selected the date jan 2020 - febr 2020,
jan 2019 - febr 2019 should come for the same months to compare better. Is it possible ?

select* from table
where
{{selected_Date}} or {{selected_Date}} - 1 (year)

#2

Hi @alpertungir
You currently cannot control the Field Filter code that is being injected, so you would have to use two regular Date filters instead, so you can rewrite the dates - 1 year.
If you search the forum you’ll find examples of comparison.

You might also be interested in this: https://www.metabase.com/blog/Time-Series-Comparisons/index.html