Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the dimensionality function to control what to calculate in the total,
if(dimensionality()=0,'the expression of the total avg',
'ur expression')
Use the dimensionality function to control what to calculate in the total,
if(dimensionality()=0,'the expression of the total avg',
'ur expression')
Many thanks. This works well, exactly what I was looking for.
Best regards