Hi @shankisaiyan, QS just launched the new Level-Aware Calculation capability. For you problem you can directly defind Mgr_Score= sum(average(employee_score, [emp_login])). Drag “Manager name” and “Mgr_Score” into the visual should give you the correct answer.
Do you need the Employee Login field in your final visual? I think Emily’s solution will work if you remove that field from the visual. Maybe you will need two visuals side by side - one at the Employee level and another at the Manger level.
hi @emilyzhu , may i know how can i display just manager with the final metric of sumover(avgover)?
I realised that if i do not put in employee in the group, there will be an error.