Reporting on Estimated vs Actual for Top-Level Items
![]()
Hi,
I'd like to be able to generate a report containing a table which shows each top-level (epic) work item down the left hand side, and each of my project's sprints along the top. Each table cell will then display the estimated/actual work for a work item from its lower level tasks. I'm happy to use BIRT to create a custom report - all I'd like to know is the estimate/actual data for low-level tasks stored by the Data Warehouse for each top-level item, or would this involve traversing parent/child links to manually calculate this information? Thanks, Simon |
One answer
![]()
On 1/21/2010 5:38 AM, simfish wrote:
Hi, To do the roll-up from children to parents, you'll need to calculate it manually (i.e. the roll-up is computed, not stored). We have a sample report called Work Progress which displays a table with a hierarchy of work items, and does a sort of roll-up of the progress, this might be a good place for you to start. You can find it here: https://jazz.net/wiki/bin/view/Main/ReportsCentral Hope this helps. james RTC Reports Team Lead |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.