Bugs by Priority Excel Report
The Bugs by Priority report in Office Excel shows the distribution of active Bugs, grouped by priority. For information about how to access this report, see Excel reports.
Note
You can view the Bugs by Priority 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 Configure or redirect process guidance.
Data in the Report
You can use the Bugs by Priority report to understand the distribution of active Bugs by priority. As the following illustration shows, this report is based on a PivotChart report that shows the last four weeks of the data captured for Bugs. This data is stored in the data warehouse.
You can review the Bugs by Priority report to determine the overall distribution of Bugs by priority. Specifically, you can find answers to the following questions:
How many priority 1, 2, and 3 Bugs are active?
Is the team resolving priority 1 Bugs before resolving priority 2 and 3 Bugs?
Required Activities for Tracking Bugs
For the Bugs by Priority report to be useful and accurate, the team must perform the following activities:
Define Bugs, and specify their Iteration and Area paths.
Note
For information about how to define area and iteration paths, see Add and modify area and iteration paths.
Specify the Priority of each Bug.
Update the State of each Bug as the team fixes, verifies, and closes it.
Customizing the Report
You can customize the Bugs by Priority report by opening it in Office Excel and changing the filter options or a column field list for the PivotTable report. You can customize this report to support other views, as the following table describes.
View |
Action |
---|---|
Distribution of Bugs for an iteration |
Change the filter for Iteration (default=All) |
Distribution of Bugs for a product area |
Change the filter for Area (default=All) |
Distribution of Bugs by severity |
In the Columns PivotTable Field List, replace Priority with Severity |
Distribution of Bugs for the last six, eight, or more weeks |
In the Columns PivotTable Field List, replace @@Last 4 weeks@@ with a different Set |
Distribution of resolved or closed Bugs |
Change the filter for State to resolved or closed (default=Active) |
For more information about how to work with and customize PivotTable and PivotChart reports, see the following pages on the Microsoft Web site: