Is there a way in JIRA to query the time taken for an issue work it's way across a scrum or kanban board? e.g. "how long has issue X taken to get from 'To Do' to 'Done'" or 'To Do' to 'In Progress'? I've seen a number of related posts but they same to be related to how long an issue has been in a particular status, and they only seem to produce a result once the issue is closed/done.
I would like to create a live report that gives me a breakdown of all issues on a board, the time they've currently spent in the column they're currently in, as well as an aggregated sum of how long it's taken them to get there. i.e.
Issue x has been in 'Testing' for 4 hours, and it has taken issue x to 4 days to transition from 'To Do' to be in 'Testing'
I think you will need to write some code to get such a report.
You could use Script Runner to create a custom script to retrieve a list of ChangeHistory items for each issue that shows up in a specific board.
Here documentation of the ChangeHistory class: https://docs.atlassian.com/jira/latest/com/atlassian/jira/issue/changehistory/ChangeHistory.html
Hope that helps
We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG