Average number of days for each month(for a big database)

[#1]

Hello,

I have a database with over 80000 entries among which, for each month , I have hundreds of entries per client concerning the number of days required to fulfiil a client's odrer. I have to calculate the average number of days that was needed to fulfill a client's order for each month in order to compare the results between the different months. I've tried the following command line but it doesn't work:

AVG(Sum(NetWorkingDays)<Month>)

I've also tried the following:

aggr(sum(NetWorkingDays),Month)) / Count(Month)

Thank you all for your help & Regards

MJ

[#2]

can you try:

avg(aggr(avg(NetWorkingDays),Month)))

Kiran.

[nagaiank · Accepted solution]

While the solution proposed by Kiran above gives the average of monthly averages, if you want only monthly averages, use the following in the chart:

Dimension: Month

Expression: Aggr(Avg(NetWorkingDays),Month)

[#4]

Thank you both for your reply, it worked.

Regards,

Marie Joelle

[#5]

Thank you both for your reply, it worked.

Regards,

Marie Joelle