Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How to calculate the average time logged on jira tickets?

Vineet Kumar
Vineet Kumar March 15, 2016

Hi All, Is there any gadget available which can calculate the average time spent on the tickets when queried? eg how would i calculate the time average logged time for the bugs which are closed and have few conditions which can be queried? Please advise

Watch
Like Be the first to like this
484 views

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Answer accepted
Vasiliy Zverev
Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
March 15, 2016

I can offer you to use work around and get this information from a database. Here is a SQL for it:

Select
	(sum (workLog_grByIssue.timeworked_Sum)/(60*60))/COUNT(jiraissue.ID)
	, issuetype.pname
from
	(
		Select
			worklog.issueid
			, SUM (worklog.timeworked)	as timeworked_Sum
		from
			worklog
		group by
			worklog.issueid			
	)	as workLog_grByIssue
	join jiraissue	
		join issuetype on jiraissue.issuetype = issuetype.ID
	on workLog_grByIssue.issueid = jiraissue.ID
group by
	jiraissue.issuetype
	, issuetype.pname
Reply
Atlassian logo
Answers Developer Questions
TAGS
AUG Leaders

Atlassian Community Events

    See all events