I wanted to add a where statement that loads data that have the timestamp within the last 60 days.
What would this look like?
check this: everyday sum of past 5 days
i hope that helps
Do you mean you want to load last 60 Days Data.
In that case use
LET vPeriod= Today()-60
Where Timestampfield = $(vPeriod);
Make sure timestamp format of both is same.
Retrieving data ...