Average per Month

[danieldors]

Hello,

Im trying to chart the avg number of cases per month, my data is based on days, when I use the parameters below I get an avg for the month but per day and not for the entire month.

=[dateReceived.autoCalendar.Month]

=avg(RFAReceivedAMS)

Thank you.

[sergio0592]

Hi,

Maybe you're looking for calculate average of daily average. So, try with :

=avg(aggr(avg(FRAReceivedAMS),dateReceived))

[danieldors]

It still provides the average per day for each month example Jan returns 4,000, should be around 90K.

Thank you.

[sergio0592]

Can you send sample and exopected output?