avg(aggr(count()) not delivering correct total average

[Arno]

Dear all,

I am trying to calculate the average of the used equipment per catagory over a period of time.

For this I am using the following expresession: Avg(Aggr(Count(distinct TANK),[Contract Name], Periode))

This is perfectly working on the catagory level ("Contract Name") but the total average is not correct, means showing the average of the averages per catagory instead of total average (see picture attached).

Do you see, what I am doing wrong?

Many thanks, Arno

[OmarBenSalem · Accepted solution]

Use the dimensionality function to control what to calculate in the total,

if(dimensionality()=0,'the expression of the total avg',

'ur expression')

[Arno]

Many thanks. This works well, exactly what I was looking for.

Best regards