I'm trying to calculate the previous week's sales vs the weekly average of the past month's sales, i.e. in the past month, what is the average sales for each week.
I can do the first part, the previous week's sales with =sum({<date= {">=$(=Date(weekstart(MAX(date)-7)))<$(=Date(weekend(MAX(date)-7)))"}>} Gross_Consideration_Eur )
However, I'm not sure how to get the weekly average of the past month. How can I do this?
