Process - Reporting Rework Faults

The intention is to standardize the way that DevOps cases are documented, so that the issues list can identify rework bugs and what caused the issue.

Using

Devops/Queries.

Configuration

Create a query with the following columns:

• Title
• Assigned To
• State
• Sub state
• Priority
• Severity
• Created Date
• Tags
• Work Item Type
• Bug Type
• Fault
• Hotfix in Release

Add criteria to select the data, typically:

• Work Item Type - Any
• State - Any
• EITHER/BOTH/NEITHER - depending on requirements.
  • Tags contains - select your tags
  • Custom Customer Contains - Enter a part of the customer

If possible, use a shared query or create a shared query.

An example query is here:

• Shared Queries/DevOps Extract for Analysis

Create a DevOps Bug List spreadsheet from template.File:Client BugList Analysis.xltx

Exporting

Run the Query.

Use the triple-dot menu on top right.

Choose Export to CSV

Open CSV

Copy all data (minus headers)

Open DevOps BugList spreadsheet

Paste data into first tab (DevOps Logs).

Go to second tab (Analysis)

Click Data/Refresh All.

Save.

The Analysis tab will break down the issues in the list and summarize the data.

The analysis provided:

• Total Bugs
  • Filters:
    • By State - you can select the State from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per state.
• Bugs by Severity
  • Filters:
    • By State - you can select the State from the "State" drop-down filter in the header.
    • By Severity - you can select the severity from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per severity.
• Bugs by Priority
  • Filters:
    • By State - you can select the State from the "State" drop-down filter in the header.
    • By Priority - you can select the severity from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per priority.
• Bugs by System
  • Filters:
    • By State - you can select the State from the "State" drop-down filter in the header.
    • By System (Area Path)- you can select the severity from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per system (area path).
• Bugs by Bug Type
  • Filters:
    • By Bug Type - you can select the bug type from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per bug type, and fault beneath that.
• Bugs by Fault
  • Filters:
    • By Fault - you can select the bug type from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per Fault.
• Bugs by Parent
  • Filters:
    • By Parent - you can select the parent case from the "Row Labels" drop-down filter in the header.
  • Reporting count and percentage per Parent case.

If you want more information on each of the bugs that were part of that group in the analysis, double-click on the count to the right of the group - a new tab will open up showing all of the bugs that match the count (usually called "Detail1").