'Other' in dimension limit is grouping all values.

[Anonymous]

Hi all,

I have an issue where i am taking sum of total working hours of all employees and dividing it with actual working hours per month.

Sum(actual working hours for Jan 2017) = 184, for Feb it's 168 for Mar it's 184.

My expression says : sum(working hours)/ sum(aggr(sum distinct actual_hours),Area,Month)

The 'Other' value is showing wrong, it should be 15 but it's showing 9. Please see the attached qvw.

[sunny_talwar]

May be this

Sum(Working_Hours)/If(Len(Trim(Area)) = 0, Sum(Aggr(hours, Month)), Sum(hours))

[Anonymous · Accepted solution]

Thanks for the reply Sunny, but my requirement says that i should consider all month irrespective of whether data is present for that month or not. So what i did is i stored this value

sum(aggr(sum(hours),Month)) into a variable and then used this variable in chart expression.