Because I don't have the real data and real data model, but according to what you said,
I think maybe you need to see the data from another perspective. Because I think according to you said, just when the task is done, then you know whom the task really belong to.
So for the tasks that is not done. if your dashboard is real-time, I think you can try to join these tasks to the different person according to the time.
If what I understood is wrong, please let me know. And if you can give a scenario, that would be better.
Thanks for your comment
Lets consider only task2 and task3 from the table in my first message. Lets assume they have been completed 10/01/2018 at 11:30
Task TaskStartDate TaskEndDate task2 09/01/2018 12:20 10/01/2018 11:30 task3 06/01/2018 06:00 10/01/2018 17:30
So the table for the chart will be like below:
[0/1 means 1 task has been assigned, but not done, therefore performance is 0%)
X-axis shows each day, Y-axis performance
Day Person1 Person2 Person3 06/01/2018 0/1 0% 0/1 0% 0/1 0% 07/01/2018 0/1 0% 0/1 0% 0/1 0% 08/01/2018 0/1 0% 0/1 0% 0/1 0% 09/01/2018 0/1 0% 0/2 0% 0/2 0% 10/01/2018 0/2 0% 1/2 50% 1/1 100%
The main issue which I have is how to make the uncompleted task will be 'moving" until is done
Hope this shows better what I would like to make in qlikview
Thank in advance