I want to make a report that shows time spent on a issue considering all the holds and working hours. Issue with the time to resolve field is that it shows time remaining for SLA to breach. Apart from this, I also want to show SLA met/breached in a column as well based.
Please note that our agents do not log work time on issues. Is there any possible way to extract such information.
Also, you can consider other solution Time in status for Jira Cloud app - automatically calculate the time each ticket or issue was on each stage of the workflow (in progress, on hold, etc.).
To select issues that have Met or Branched SLA you can use JQL filter (for example "Time to Response" != everBreached())
Also, you can exclude not working hours from a calculation using the Multi-Calendar feature.
Additionally, you can monitor time spend data in graph view for issues you need.
Hope it will help
Hi @hmnaqvi ,
Functionality of displaying time spent on each status is not possible out of the box. You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.
Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project).
On October 20, 2021, Atlassian published a security advisory for Jira Service Management. The full advisory is available at this link. We've seen a number of questions already asking for...
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