Azure DevOps Report for User Story Status History

Question

1. How long does a story stay in each status, on average? (Q: Which statuses take the most time)
2. How many times is a story set to a status, on average? (Q: When and how often are we moving backward in the flow)
3. How many times does a story move backward for each team member? (Q: Where should we focus our training efforts)

Answer 1

Unfortunately, there is no simple method to achieve this. Your best chance will be to create a Power BI report or an Excel spreadsheet, whatever you are most acquainted with. Even then, you'll run into issues with #2 and #3. Microsoft does not provide an easy mechanism to query the history of each status across all work items.

#1, on the other hand, is achievable with PowerBI and Excel.