average

[iswarya]

How to find average of all the month for each person

[Simon_Astakhov · Accepted solution]

Hi. You can reach it by some ways.

First is divide for amount of monthes like (your expression)/count(distinct [Month] & [Year])

Second is using AGGR function like avg(aggr(your expression, [person], [Month], [Year]))

[Year] field is optional in case of many years of data.