4 answers
Hello @Sampath ,
As far as I understand you are trying to calculate the resolution time of the tickets. For that I can suggest you a marketplace app which will give you ready-to-go reports. Timepiece - Time in Status for Jira ,the oldest and the most comprehensive "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need. Our app is available for both Jira Cloud, and Data Center.
Timepiece mainly allows you to see how much time each issue spent on each status.
Status Duration report (please see the screenshot above) which shows how much time each issue spent on each status. You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc.
The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.
Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs.
If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.
Hope it helps,
Gizem
Hi @Sampath
Looks like you are trying to find out the completion/resolution times for your Jira Issues. You can use Jira Rest API's to pull this data from issue changelogs. Or You can create your own custom fields and apply Jira automation to populate those.
Alternatively if you are open to try a mktplace app, pls do take a look at
With this app you generate resolution times for your Jira Issues. The app allows you to group your statuses and it calculates and sums up the total time the issue takes while moving through the workflow right from the initial status to the completed one. The screen below shows the cycle time report similar to one in your requirement.
Also the app has many reports to meet a variety of time in status use cases.
Disclaimer : I work for the vendor who built this app
Hi @Sampath 👋
Unfortunately, this can not be achieved with JQL, but you can grab this data from issue changelogs using Jira Rest APIs, or you can make your own custom fields and set up Jira automation to fill those in.
Also, if you consider installing third-party add-ons, try out Time In Status add-on.
1. You can get calculation of days taken for each ticket with Time in Status report.
2. Also the Assignee time report will notify you of how much time each Assignee spent on each task.
4. For more in-dept analysing try out Pivot view table. We can evaluate how much the time in the In Progress status has changed depending on the number of tasks, and we can also “dive deeper” and see which tasks have spent a lot of time.
You can also book a live demo - we'll show you the application inside out and answer all your questions.
Add-on developed by my team.
I hope you find this helpful 🚀
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.