Bug Progress Excel Report

You can use the Bug Progress report in Office Excel to track the team's progress toward resolving Bugs. This report shows the number of Bugs in each state over time. For information about how to access this report, see Excel Reports (GovDev).

NoteNote

You can view the Bugs Progress report from the Bugs dashboard. You can access this dashboard only if your team project portal has been enabled and is provisioned to use Microsoft Office SharePoint Server 2007. For more information, see Access a Team Project Portal and Process Guidance.

Data in the Report

You can use the Bug Progress report to understand how well the team is finding, fixing, and closing Bugs. This report is based on a PivotChart report that shows the last four weeks of data captured for bugs. The data is stored in the data warehouse.

Bug Progress Excel Report

Required Activities for Tracking Bugs

For the Bug Progress chart to be useful and accurate, the team must perform the following activities:

  • Define Bugs, and specify their Iteration and Area paths.

    NoteNote

    For information about how to define area and iteration paths, see Create and Modify Areas and Iterations.

  • Specify the Priority of each Bug.

  • Update the State of each Bug as the team fixes, verifies, and closes it.

Interpreting the Report

Customizing the Report

See Also