The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How Can to calculate Average Time Spent on Tickets

Monika Rani
Community Champion
September 5, 2024

Hi,

I’m looking to calculate the average time spent on issues. After exploring apps and community answers, I’ve only found solutions for average time in status. However, I need to calculate the average time spent (logged time) on all closed issues for a specific year. Can anyone suggest a solution?

Thank you!

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

4 votes
Answer accepted
Walter Buggenhout
Community Champion
September 5, 2024

Hi @Monika Rani,

That request needs you to aggregate a lot of data and then calculating averages on them. I would definitely recommend you to look at a BI reporting solution. You may have one available in your company, but if you don't, you might want to look at EazyBI for this:

Screenshot 2024-09-05 at 11.51.46.png 

I built the above on report quickly, using resolution as a means to detect closed issues.

Hope this helps!

Monika Rani
Community Champion
September 5, 2024

Thank you @Walter Buggenhout for your reply, I am using Power BI to achieve this report. 

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events