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)