Hi,
I’d need some help to better understand how i can return per employee the average salary of its departement.
Thanks
Solved
Return per employee the average salary of its departement
- New Here
Best answer by Tobias Gorsia
Hi
It sounds like you want each employee to display the average salary of their department, for example, every employee in HR should see the same departmental average.
Here’s how to do it step-by-step:
Create a metric for the departmental average as
Avg Salary by Department = AVERAGE(Salary) BY Department
Reference that metric in your employee list, by linking through the Department dimension:
Employee Dept Avg = [Avg Salary by Department] BY Department
This will return the same average value for all employees in the same department.
If the result isn’t unique per employee, double-check that there are no extra dimensions (like Month or Year) in either metric otherwise the context won’t match.
If you still see multiple values per employee, could you share a screenshot of both metric structures? or could you please share the formula you’re using for the department average?
It’ll help us understand how the calculation is scoped and why it might not be returning a unique value per employee. Once we see it, we can guide you on the best adjustment. That’ll help check the dimension scoping.
Best,
Tobias
+12- Master Helper
You can do
Step 1 calculate average Salary at department level : Avg Salary= Salary[remove avg: employee]
Step 2 assign avg salary to employ: Avg Salary[by:→ ‘employee by department’]
‘employee by department’ is a metric or property that map each employee to a department.
- New Here
Hi,
Thank you for your reply, it helps.
I have my metric where i know the average salary by department and I have a list where each employee is assigned to a department.
When i apply your suggestion i have :
The problem is it’s not matching a unic average salary for an employee.
Any suggestion ?
Thank you
+12- Master Helper
You may want to check you dimensions included in average salary and employee by deparment. Is there a Month or Year dimension included?
Min Li
- New Here
Dimension for average salary is departement and employee by department is a list so no dimensions set. There is no Month or Year dimensions included.
Thanks
- Employee
- Answer
Hi
It sounds like you want each employee to display the average salary of their department, for example, every employee in HR should see the same departmental average.
Here’s how to do it step-by-step:
Create a metric for the departmental average as
Avg Salary by Department = AVERAGE(Salary) BY Department
Reference that metric in your employee list, by linking through the Department dimension:
Employee Dept Avg = [Avg Salary by Department] BY Department
This will return the same average value for all employees in the same department.
If the result isn’t unique per employee, double-check that there are no extra dimensions (like Month or Year) in either metric otherwise the context won’t match.
If you still see multiple values per employee, could you share a screenshot of both metric structures? or could you please share the formula you’re using for the department average?
It’ll help us understand how the calculation is scoped and why it might not be returning a unique value per employee. Once we see it, we can guide you on the best adjustment. That’ll help check the dimension scoping.
Best,
Tobias
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.