Cycle Time (85th percentile) report from Azure DevOps

Report on cycle time (activated → closed), 85th percentile from an Azure DevOps export, tracked month by month against your own target. ReportInSite runs in your browser, so the file is read on your device and nothing is uploaded.

Try it with sample data Open the tool →

How to export it

Run the query, then Export to CSV with the Activated Date and Closed Date columns. Dates follow your Azure DevOps locale; US-format exports are read month-first.

WIQL

SELECT [System.Id], [System.WorkItemType], [System.AreaPath], [Microsoft.VSTS.Common.ActivatedDate], [Microsoft.VSTS.Common.ClosedDate]
FROM WorkItems
WHERE [System.TeamProject] = @project
  AND [System.State] = 'Closed'
  AND [Microsoft.VSTS.Common.ClosedDate] >= @today - 180

Then open ReportInSite, go to the Data tab, choose Export from any app, pick Cycle time (activated → closed), 85th percentile and load the file. The recipe fills in the column mapping and the calculation; you can change any of it before importing.

What you get

This recipe feeds Flow › Cycle Time (85th percentile). It rolls into the steering scorecard, the portfolio roll-up, trends and the PDF packs alongside every other source.

Steering scorecardThe value lands on Flow › Cycle Time (85th percentile) for each team, scored red / amber / green against your target.
Flow & DORA reviewItem-level charts from the loaded file: cycle-time scatter, work item age and cumulative flow.
Portfolio roll-upEvery team side by side on the heatmap, whichever tool each one uses.
TrendsDated rows fill earlier months, so the direction of travel is there from the first import.

Related reports

Every recipe, with export steps for each app, is in the Playbook under Data from any app. No recipe for your app? The custom mapper reads any CSV or Excel table.

Nothing to install, nothing to upload.

Try it with sample data All reports →