Forum Discussion
Human resources personal change
Hi everyone 😀. We have a table with all the workers (160 approx). They are classified by teams 1-9. Typical, data (ID, Name, Surname, Team, etc.). We have some measures like: real time worked, stop time, number of days worked, etc
The problem is that one of the workers has been reassigned to another TEAM (for example, 1 to 6) in the middle of the year. If we change it manually measures like average, etc. would be incorrect, for example before the change, the number of workers was 9, and after it would be 10, so the previous data reported would be wrong. Any idea to move workers between categories and no affecting measures and filters, so they still can can work?
Thank you
Hi, Javismws
One way to handle this situation is to create a new table or data structure that records changes in team assignments over time. When calculating a measure, you can join this table with the original worksheet and filter it based on the date of interest.
For example, 1 starts at A and then moves to C in the middle of the year. When you calculate the measures for that employee in the first half of the year, they will be associated with A, and in the second half of the year, they will be associated with C.
This approach allows you to maintain historical accuracy in your measurements, while also being able to handle changes in your team's assignments. It also has the added benefit of allowing you to keep track of each employee's team assignment history.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Javismws
One way to handle this situation is to create a new table or data structure that records changes in team assignments over time. When calculating a measure, you can join this table with the original worksheet and filter it based on the date of interest.
For example, 1 starts at A and then moves to C in the middle of the year. When you calculate the measures for that employee in the first half of the year, they will be associated with A, and in the second half of the year, they will be associated with C.
This approach allows you to maintain historical accuracy in your measurements, while also being able to handle changes in your team's assignments. It also has the added benefit of allowing you to keep track of each employee's team assignment history.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.