Need help calculating weekly averages using either TSVB tables or Scripted fields

As an enhancement to this, would it be possible to generate an average for the past 7 days for each and every date?

For such visualizations, you should use TSVB (Moving average aggregation) ,
example: Moving Average Visualization - #2 by nickpeihl