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.