JIRA 5.2: How to show Turn Around Time (Resolved Date - Created Date) on issue navigator?

Hi,

Is there any way to show the Turn Around Time (Resolved Date - Created Date) as one of the columns on the issue navigator and if possible also export the same to the excel file?

Regards,

Rumit

3 answers

1 accepted

0 votes
Accepted answer

Add a scripted field using Script Runner and add the below code

return (issue.resolutionDate != null) ? String.format("%d day(s)",(int)((issue.resolutionDate.getTime() - issue.created.getTime()) /(1000*60*60*24))) : "N/A" ;

Hi Renjith, I have added the script given by you to the scripted field. However, It always returns 'N/A' even for the issues that are resolved/closed. Regards, Rumit

Ok, I 've corrected the formula given by Renjith.

It should be 'issue.getCreated()' instead of 'issue.created'.

(issue.resolutionDate != null) ? String.format("
%d day(s)",(int)((issue.resolutionDate.getTime() - issue.getCreated().getTime()) /(1000*60*60*24))) : "N/A" ;

So, here I get the TAT in 'Days' . Is there any way to format this value to a TIME? e.g. 14:10:44 (HH:MM:SS)?

Regards,

Rumit

Hi,

Thanks for this post. It is useful for me in creating the custom field for the same requirement.

With the help of above scripts, I have created a custom field to display the TurnAround Time. This field is visible in each of my Jira tickets.

Now I would like to display this in a dashboard with the below value fields:
1. My Release Version
2. No. of tickets raised for each version
3. Turnaround time of the respective tickets

I am not sure which kind of dashboard I should select for displaying all these from Jira.
Could anyone please help me to achieve this requirement?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,225 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you