title: Google Data Studio date aggregation - average number of daily users over time
body: <p>This should be simple so I think I am missing it. I have a simple line chart that shows Users per day over 28 days (X axis is date, Y axis is number of users). I am using hard-coded 28 days here just to get it to work.</p>
  
  <p>I want to add a scorecard for average daily users over the 28 day time frame. I tried to use a calculated field <code>AVG(Users)</code> but this shows an error for re-aggregating an aggregated value. Then I tried <code>Users/28</code>, but the result oddly is the value of Users for today. The division seems to be completely ignored.</p>
  
  <p>What is the best way to show average number of daily users over a time frame? Average daily users over 10 days, 20 day, etc. </p>