I want to create report that shows the 7 day moving average for sales
While that isn't available in the online reports, you can view rolling weekly/month/yearly summaries in the Dashboard app!
Check it out here: https://squareup.com/pos/dashboard/app
Square Community