Avg values with Aggr are not giving me what I am after
I am trying to identify the average calls per day for however many agents I select. The call number for the day is not aggregated which is what I need. I am trying to use Aggr to find the average calls by day and agent. When I use Aggr I am not getting the same value as when I pre-aggregate the values by agent and day and then find the average.
Wrong Vaue: (but at the detail level I need)
My aggr formula at the detail level: Avg(Aggr(sum(CallCounter), %DateKey, %AgentKey))