4 Replies Latest reply: Oct 24, 2014 3:21 AM by Jyothish KC

# 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))

Value returned is 13.7.

Correct Value

Pre-Aggregated values:  32 is the average # Calls.

 AgentName CallsQty %DateKey Bob 14 8/26/2014 Bob 18 8/29/2014 Bob 24 8/27/2014 Mary 26 8/26/2014 Mary 27 8/23/2014 Mary 27 8/31/2014 Mary 28 8/24/2014 Mary 28 8/27/2014 Mary 29 8/5/2014 Mary 30 8/25/2014 Mary 32 8/12/2014 Mary 32 8/17/2014 Mary 34 8/6/2014 Mary 34 8/20/2014 Mary 35 8/2/2014 Mary 35 8/11/2014 Mary 36 8/18/2014 Mary 36 8/30/2014 Mary 37 8/3/2014 Mary 38 8/13/2014 Mary 39 8/9/2014 Mary 40 8/16/2014 Mary 41 8/10/2014 Mary 43 8/4/2014 Mary 45 8/19/2014 Average 32

Thank you.

• ###### Re: Avg values with Aggr are not giving me what I am after

Hi Darrin,

IS this is what you want?

Regards

KC

• ###### Re: Avg values with Aggr are not giving me what I am after

If you remove the dimension then you will get 32.

Regards

KC

• ###### Re: Avg values with Aggr are not giving me what I am after

Jyothish,

Thank you for the quick reply.  There was actually no formula in the file.

I did figure it out.  I have multiple facts concatenated and it seems to be changing how the formula is aggregating.

I added the following set analysis and it resolved it.

=Avg(Aggr(sum({<FactType = {Calls}>} CallCounter), %DateKey, %AgentKey))

Thank you.

• ###### Re: Avg values with Aggr are not giving me what I am after

Hi Darren,