In the Average Daily metrics I've seen (e.g., Average Daily Visits,
Average Daily Revenue), there is a technique that utilizes the
Approximate Count Distinct function to calculate the number of days over
a time dimension of your choosing. It works pretty well...except, every
once in a while, it comes back missing a day. Below is an example using
this function broken down by week. Across all reporting suites we
support, the week of July 12, 2020 shows about 6 days instead of 7. Same
thing happene...