Average for Group by Time Period Can Act Weird for First or Last Group if some data missing

[Axirr]

E.g. if first data is a Sunday, weekly average will be that single data point

Technically correct, but usually substantially overstates

Impute zeroes in any time group we're actually dealing with? That has it's own problems, may underestimate
Impute average?