Extracting test results chart, sorted by tester in Azure DevOps Test Plan

I’m a test manager and I use the Test Plan module of Azure DevOps to manage manual tests. I also use it for managing UAT execution. I typically have a large number of business users (10+) assigned as testers. When I generate charts to show how many tests are assigned to each tester, I find that the first 8 testers, with the highest number of assigned tests, were displayed, but the rest were clustered in a group called “Other”.

  1. Is there a way to have all of the testers displayed along with the number of tests assigned to each?
  2. Is there a way to extract the raw data from Azure DevOps, as a spreadsheet or CSV, so I can manipulate?
1 Like

Yes, to both of your questions.

You use Queries from the Work module. Once your query is returning the data you need, you can either see if generating charts from that query work for you, or you can use Excel with the Teams add-in to connect to your Azure DevOps query and retrieve the data for manipulation that way.