Hello everyone !
I need your help and advice. I would like to create a graph that displays the base salary of all employees having the same key properties as the employee selected in the filter:
Emp Num | Region | Business Line | Job Level | Job Family | Base Salary |
2345 | North Amercia | Asset Management | 2 | Sales | 45,000 |
2322 | North Amercia | Asset management | 2 | Sales | 43,500 |
8736 | Southern europe | Services | 4 | Sales | 73,000 |
5673 | Southern Europe | Support | 3 | HR | 55,000 |
2376 | North America | Support | 2 | HR | 37,000 |
2389 | North America | Asset Management | 3 | Sales | 53,000 |
2329 | North America | Asset Management | 2 | Sales | 31,000 |
For example, if the user enters the Emp Numb 2345, the bar chart will display the average base salary for employees 2345+2322+2329, to be able to compare his position with the market average
Is there a way for a set analysis to modify the results of the Base Salary taking into account the key properties of the employee selected ?
Thanks for your help !
