Unfortunately, there is no way you can find the time spent (start date and end date) on the particular status per issue with JQL Query, but you can achieve it with Time in Status for Jira Cloud by SaaSjet.
With this tool, you can easily track the number of times an issue has been in every status. Also, you can get the information about the time in status for each stage in a workflow and the number of times a task has gone from status to status. Safe to say, this add-on is a good way to get a helicopter view, find out bottlenecks and unproductive delays in your processes.
Moreover, you can export all necessary data as a report in XLS or CVS file and set up a teamwork schedule to exclude non-working hours or days. Based on this extracted custom report you can proceed with your corporate analysis.
The add-on is constantly improving and develops the ability to show an average time spend in status in the grid. So any time soon, this data can be seen directly in the application.
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events