How can I obtain a Work Item "Start Time" (when it moves from the backlog to In Progress)?

[GCushnahan]

Hi,

I'm trying to workout what my current cycle time (when an issue starts to when it finishes) is for completing work items.

When I extract a .csv of all my issues from Jira, I can get a created date and a resolved date but no date for when the work item starts e.g. when it moves from the backlog to Dev in Progress.

I read somewhere that if the export doesn't provide the relevant data, I "might need Jira administrative access to extract more detailed data, such as workflow transition logs".

Please advise on how I can obtain this "start time".

Many Thanks

[Bill Sheboy]

Hi @GCushnahan -- Welcome to the Atlassian Community!

That information is in the issue history, but it is not easily accessible (and certainly not exportable).  It can be extracted by calling the REST API...one issue at a time.

Atlassian's built-in interpretation of a Cumulative Flow Diagram (CFD) can be used to see such measures for software projects, although that report has many challenges.  For more accurate measures, CFDs, and time-in-status type of reporting, customers may use marketplace apps.

If you wanted to specifically export the the date / time when an issue started an "in progress" status, a custom field could be added and an automation rule used to capture when the issue first enters that status.  For issues currently in such a status, the statusCategoryChangedDate field contains that information.  For older / already completed issues, the value could only be found looking in the history.

Kind regards,
Bill