Cumulative Average is good, but if you want to compare each row to your average for the last 7 days, that becomes trickier to do, since each row is showing the average of it's own last 7 days.
If you don't want to do Cumulative Average, and really need a "hard last 7 day average", you can create ...