Azure DevOps - LetPeopleWork/MonteCarloCSV GitHub Wiki

In this section, you learn how you can extract a CSV file from Azure DevOps that can serve as input for MonteCarloCSV.

Create a Query

First, we need to create a new query. Following is an example, of course, you can tune it to whatever makes the most sense for you.

We will filter for these things:

Filter	Description
State = Closed	We only need closed items
Closed Date >= @Today - 90	Filter for items that were closed in the last 90 days
Work Item Type = User Story / Bugs	We only care about those types, not about Tasks nor Features/Epics

Add Column to Query

Go to the Column Options and make sure that the Closed Date is part of the columns:

Export as CSV

Once you created the query, you can switch to the Results view and click on Export to CSV and it will download the file:

Be aware that the CSV might contain more columns than what you see in the browser. Just make sure the Closed Date is there. For me it looks like this:

Title,Work Item Type,State,ID,Closed Date
,"User Story","Closed","169780","10/6/2023 8:48:01 AM"
,"User Story","Closed","169198","10/9/2023 6:55:44 AM"
,"User Story","Closed","169197","10/9/2023 11:59:24 AM"

Date Format

In order to check the date format, you have to open the downloaded CSV (in the browser it might be converted to your local region format).

As you can see above, the format I had was not matching with the browser (compare the screenshots). If you also have the "American date/time" format using the hours, minutes, seconds and AM/PM, you can use the following format: %m/%d/%Y %I:%M:%S %p

Now you should be ready to go to try the tool! Have fun.