Page - Panel or Gauge - Formula

Page - Panel or Gauge - Formula

Hi,
I am trying to get an average on the past 7 days of records. Some days have multiple records, and others don't.  Using the simple average calculate the average based on a number of records.  I just need to take the sum of data and divide it by 7.  Is there a way to do that on a page?