Avg values with Aggr are not giving me what I am after

[Anonymous]

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.

[jyothish8807]

Hi Darrin,

IS this is what you want?

Regards

KC

[jyothish8807]

If you remove the dimension then you will get 32.

Regards

KC

[Anonymous]

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.

[jyothish8807]

Hi Darren,

I simply add a expression:

Sum(CallQty)/Count(Dates)

Regards

KC