Azure DevOps dashboard

Question

Hi All,

I would like to show on dashboard a bar chart of number of bugs that are created and closed per Sprint. Currently, I am unable to do so as it shows me number of bugs open or closed in the current sprint. But how do I view in if I want to draw insights on how many bugs are appearing in each sprint?

Could you please tell me? Thanks.

Answer 1

To create a bar chart that shows the number of bugs created and closed per Sprint in Azure DevOps, you will need to utilize queries to gather the relevant data across multiple sprints. Here’s how you can achieve this:

1. Create Queries for Bugs: You can create queries to filter bugs based on their creation and closure dates. For example, you can create a query that lists bugs created in each sprint by using a date filter that corresponds to the sprint dates.
   • Use the query editor to set conditions like Created Date >= [Start Date of Sprint] AND Created Date <= [End Date of Sprint] for each sprint.
   • Similarly, create another query for bugs that were closed during each sprint using the Closed Date.
2. Charting the Data: Once you have the queries set up, you can create charts based on these queries. Azure DevOps allows you to create status or trend charts from the query results.
   • You can add these charts to your dashboard, ensuring that they reflect the counts of bugs created and closed for each sprint.
3. Adding to Dashboard: After creating the necessary charts, you can add them to your dashboard. You can use the Query Results widget to display the results dynamically, or you can create specific charts for better visualization.

By following these steps, you should be able to visualize the trends of bugs created and closed across different sprints, allowing you to draw insights on how many bugs are appearing in each sprint.

---

References:

• Define, capture, triage, and manage bugs in Azure Boards
• Track progress with status and trend query-based charts