Frank Bacchus
Member
Hi:
My attached file contains data to simulate the tracking of issues. I would like to create a few pivot tables with pivot charts that show the following:
(1) Average number of days that assignee has issue since opened by effort level. So this is by assignee, by effort level, the average number of days for open issues
(2) Average number of days, across effort levels that issues are open
(3) Average number of days, across the effort level that issues take to close (note for ‘closed’ issues, the modified date is the close date)
(4) Average number of days, across the effort level, by assignee that issue take to close (note for ‘closed’ issues, the modified date is the close date)
(5) And for the challenging of, using the slicer, would like to select an assignee, and their issues populates a table below the chart.
Please let me know if you gave any questions.
Thanks
frank
My attached file contains data to simulate the tracking of issues. I would like to create a few pivot tables with pivot charts that show the following:
(1) Average number of days that assignee has issue since opened by effort level. So this is by assignee, by effort level, the average number of days for open issues
(2) Average number of days, across effort levels that issues are open
(3) Average number of days, across the effort level that issues take to close (note for ‘closed’ issues, the modified date is the close date)
(4) Average number of days, across the effort level, by assignee that issue take to close (note for ‘closed’ issues, the modified date is the close date)
(5) And for the challenging of, using the slicer, would like to select an assignee, and their issues populates a table below the chart.
Please let me know if you gave any questions.
Thanks
frank