What I would like to achieve:
Select specific day (date) using dashboard filter and from this specific date take e.g. 55 days back and for this period compute e.g. sum of Sales.
Is it possible to somehow achieve this?
I defined currently selected date as
SELECT MAX(Date (Date)) BY ALL OTHER WITHOUT PF EXCEPT Date (Date)
and lagged Day as
SELECT Selected day - 55
and the metric for the sum:
SELECT SUM(Sales) WHERE Date (Date) > Lagged day and Date (Date) <= Selected day WITHOUT PF
however this does not give any results.
How to solve this, please?
Best answer by Moises MoralesView original