Why is avg() not working as expected for the Total?

[NenadV]

ExpressionData

[Kushal_Chawda]

@NenadV  make sure that you are using correct dimension names in aggr function. You need to use actual dimension names (Not dimension label) that are present in your table

[NenadV]

sure. checked

[Kushal_Chawda]

@NenadV  It will be challenging to say anything without looking at your app or sample data apart from many suggestions from @Or  & @PrashantSangle 

[NenadV · Accepted solution]

I know, I've fixed the issue in the data script by replacing zeroes with 0.5 for those who haven't scored anything.

Case closed. Thank you all.