How to add avg comparison to chart

[#1]

Hi all,

Please have a look at my attached straight forward chart.

What I'd like to achieve is very simple. When I click on an employee, I want the chart to compare that employee to the average of all other employee's. Just not sure how to go about it.

Any help would be appreciated.

Kind Regards,

W

[sunny_talwar]

Something like this?

If it is, then I can explain you the changes I made to get to this. If not then help me understand exactly what you want.

Best,

Sunny

[morgankejerhag · Accepted solution]

I think Sunny is close, but one also must remove the currently selected Employee if you want the average of the others. I have modified Sunny's expression to inverse the selection on Employee.

Avg(TOTAL {<Employee = e(Employee)>} Aggr(sum({<Employee = e(Employee)>} CallHours), Month, Employee))