I need to create metric showing performance of tasks each working day.
Tasks are done by 3 people:
- first person working from 0:00 till 7:59
- second person working from 8:00 till 15:59
- third person working from 16:00 till 23:59
In the X-axis I have days, each day contains three bars (1,2,3 person) and they show performence (amount of tasks done that day/all task assigned to the person that day)
If the task comes on 22/12/2017 16:30 it should be done by person 3, but if it has not been done by person 3 it should goes to person 1 (if done by person 1 it should be included to his performence as task done on 23/12/2017), afterwards (if still not done) to person 2 and so on unitl the task is completed
Example of the table:
I have problem with the script. How to make that task (TaskStartDate) will be moving from one person to another until is done? Should I use some loop? Could you please advise how it should look like?