Try using Time in Status for Jira Cloud by SaaSJet.
With this add-on, you can easily track how much time any type of issue spends in each of our issue statuses.
Now with new updates, you can measure: Time in Status, Status Count, Transition Count, Assignee Time, Average Time, Status Entrance Date, and Time in Status per Date.
You can view all of the reports as charts (Pie, Bar and Area Charts).
Moreover, this add-on has an advanced filtering system by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).
You can exclude breaks, non-working hours or holidays and create multiple calendars.
Hope, that this add-on will help you to create and export the reports you need.
Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...
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