I have a data table as follows
|---------------|----------------------|----------------------------|---------------|
| task_id | task_name | resource_Name | Status
|---------------|----------------------|----------------------------|---------------|
|----- 1 -----|---- task 1 ----|--------- John ---------|-- ontime --|
|----- 2 -----|---- task 2 ----|--------- John ---------|---- late ----|
|----- 3 -----|---- task 3 ----|--------- John ---------|---- late ----|
|----- 4 -----|---- task 4 ----|--------- John ---------|-- ontime --|
|----- 5 -----|--- Z Task 1 ---|--------- Adam ---------|-- ontime --|
|----- 6 -----|--- Z Task 2 ---|--------- Adam ---------|-- ontime --|
|---- 7 ------|--- Z Task 3 ---|--------- Adam ---------|-- ontime --|
|----- 8 -----|--- Z Task 4 ---|--------- Adam ---------|---- late ----|
|----- 9 -----|--- V Task 1 ---|--------- Scott ---------|---- late ----|
|---- 10 -----|--- V Task 2 ----|--------- Scott ---------|---- late ----|
|----- 11 ----|--- V Task 3 ---|--------- Scott ---------|-- ontime --|
|---- 12 -----|--- V Task 4 ----|--------- Scott ---------|---- late ----|
|---- 13 -----|--- V Task 5 ---|--------- Scott ---------|-- ontime --|
|---- 14 -----|--- Th-Task 1---|--------- Emily ---------|-- ontime --|
|---- 15 -----|--- Th-Task 2---|--------- Emily ---------|-- ontime --|
|---- 16 -----|--- Th-Task 3---|--------- Emily ---------|-- ontime --|
I am trying to count ontime tasks aginst late tasks for every resource_name in a pie chart as follows and the selected resource from a selection pane
John 50% ontime , 50 late
Adam 75% ontime , 25% late
Scott 40% ontime , 60% late
Emily 100% ontime, 0% late
I want for example to select John so the pie chart view the value of John progress only, 50% and 50% or select Scott so the pie chart change to Scott's progress values 40% and 60%
please help.
