I'm trying to make an average calculation of a period from 4 weeks ago until the beginning of my data set, measured from this week. I want it to update dynamically.
I've tried creating a calculated field using DATEADD("week", -4, [Date]). Then made a set to compare the current week (using TODAY()) to the week from my calculated field, but can't get it to work because it doesn't add the weeks from the previous year to the set (because they're bigger then this week's number - 4).
What can I do?
Try this calculation: WINDOW_AVG(SUM([Filed name]), -4, 0)