There are in general various approaches thinkable. One might be to try to apply rather quite simple conditions, like:
mod(count(distinct Date), 7) = 0
whereby it might need some further conditions to ensure that it always worked.
Another method could be to ignore some of the selections, for example to allow selections on year/month/week level but ignoring date-selections, maybe in this way:
sum({< date = >} value)
A further approach could be to change the calculation-logic in this way that always a proper average is calculated, maybe in this way:
sum(value) / count(distinct date)
- Marcus
.png "Former Employee"){kind=icon}
