Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time Spent and SLA Met/Breached

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.

2 answers

Hi @hmnaqvi 

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

Regards

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).

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Security Advisory for Jira Service Management

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...

126 views 0 1
Read article

Community Events

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

Events near you