Calculation fixed level of detail

So I want to add new calculated column, Average difficulty rating per Manager (Keeping manager as fixed), where first summing all the difficulty ratings of departments assigned to particular manager then divide by 5, to see what the average difficulty rating is for that manager.

Currently I am doing

avgOver(sum({Difficult rating}),[{Manager)}]) but somehow that’s returning wrong answer.

Please guide.

Thanks

Level-aware calculation

Its a LAC-A or LAC-W calculation

avgOver(avg({Difficult rating}),[{Manager)}])

gives the desired number on rounding up. However would like to understand what’s the formula doing. My first time with Quicksight

Hi @Gcsingh, this guide describes how the avgOver function works. Please let us know if you still have questions after reviewing the guide. Thanks!