I'm able to calculate average bucket score over one layer of data, but not on two lever hierarchy data.
A-parent-group m-group t-team 1
A-parent-group m-group t-team 4
A-parent-group n-group p-team 45
A-parent-group n-group p-team 34
A-parent-group n-group k-team 3
In above data, the average at group level can be calculated using bucketing at team level and I can get accurate results as
Now while I try to calculate average avg at parent group.
The bucketing at group level will give wrong output as: 29.83
but actually it should be 11.87