How do I extract start dates of a workitem in a status?

Question

Hello All,

As A Scrum Master
I want to understand when given features will achieve doneness
So that I can readily determine health of project

I am looking to extract data from jira which will show when a given workitem(story,task,bug) landed in a given status of a workflow.

From there, I can feed this data into a forecasting tool and determine when whole features would reach DONE.

Can anybody tell me which rest api call I would use to extract these dates?

The goal will be to end up with an extract file containing the following:

issueid,issuetype, status1, status2, status3 <---the statuses would be things like analysis, in progress, in review, ready for test, testing, done

Having this type of data will also help with continuous improvement as it will help me determine where any logjams\delays are occurring in the workflow

Emre Toptancı [OBSS] · Answer

Hello @Mike D ,

If you are interested in a ready built solution, our team at OBSS built Timepiece - Time in Status for Jira app for this need. It is available for Jira Server, Cloud and Data Center.

Time in Status contains 4 different date reports that show first/last entry/exit dates for all statuses.

The app  also gives you reports that show how much time each issue spent on each status or assigned to each assignee. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Cycle Time or Lead Time.

Time in Status uses issue histories to produce its reports so you don't need any configurations on your workflows and you can get reports on your past issues as well.

Using Time in Status you can:

* See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
* Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
* Define your custom calendars for more accurate duration reporting.
* Export your data as XLS, XLSX or CSV.
* Access data via REST API.
* Visualize your data with various chart types.

Timepiece - Time in Status for Jira

EmreT

Mehmet A _Bloompeak_ · Answer

Hi @Mike D ,

The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, then you need to extract and calculate.

Or you can try a marketplace app which does the extraction and calculation for you. Our team at Bloompeak developed Status Time app for the exact need. It has the online demo, you can see it in action. It displays status entry dates as well as status durations.

Hope it helps.

Mariana_Pryshliak_Saasjet_qysy8m · Answer

Hello @Mike D

There is a similar question in these discussions. So you can try to solve your issue by reading it:

https://community.atlassian.com/t5/Jira-questions/Extract-date-and-time-when-status-changed/qaq-p/1229519

https://community.atlassian.com/t5/Jira-questions/Extract-Release-Start-Date-Fix-Version-Start-Date/qaq-p/1136038

Also, as an alternative, you can try Time in Status for Jira Cloud. This add-on generates a Status Entrance date report, which shows the date when an issue has entered each status.

Hope it helps

Best regards, Mariana