Discussion board where members can get started with Qlik Sense.
How to find average of all the month for each person
Go to 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.