I am trying to create a table with rolling count of the current week, last 4 weeks, and last 8 weeks. I was able to create beast mode calculations for last 4 & 8 weeks, but I am lost in creating beast mode calculation for the current week. What would be the best way to calculate rolling count for the current week? Thank you in advance!
Below are the calculations for rolling 4 weeks and 8 weeks:
SUM(
CASE WHEN (`Date`) > DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK)
AND (`Date`) <= CURRENT_DATE()
THEN `Units`
END)
SUM(
CASE WHEN (`Date`) > DATE_SUB(CURRENT_DATE(), INTERVAL 8 WEEK)
AND (`Date`) <= CURRENT_DATE()
THEN `Units`
END)