I have the following which metric which gives me a running average per day.
=RunningAverage(Average([var_Port Performance - Turn Time (Days)]))
However, the problem I having is when I filter for the last 7 days, my running average will start from the Day-7, but I want it to start the runningaverage from the first day of the month even when my table is filtered to only show the last 7 days.
My date variable is [var_Day]
So, I want the running average to be
and still have my 7 day filter.
Anybody know how I can get around this?