Exclude this period
When working with weekly averages, the average fluctuated wildly as data is entered for the current week, even with your extrapolated calculation. Say I was averaging 1 per week entering that on Sunday. When a new week starts your method extrapolates that to 7 and throws off the average until the week is completed. So my trend might be 1 2 1 1 1 and the average shows 2.5 and slowly comes back down. Obviously with this data it should be between 2 and 1 and could never exceed 2. Excluding the current period from the calculation would solve this.
Great point, thanks Jeff! We fixed this in v3.0.2, so it only considers what you’ve done, and exactly how much time has passed.