5 Replies Latest reply: Aug 2, 2016 7:01 PM by Shaima Mahmoud RSS

    how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

    Shaima Mahmoud

      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.