I don’t think this is possible. The issue would arise when one of your dates is in more than one group.
For instance 3 days ago is in the 7-day average and MTD average.
You would probably need to do some SQL to allow for a single date to be in multiple groups.
1 Like