Forums

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

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

Rumit Patel July 4, 2013

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

4 answers

1 accepted

0 votes
Answer accepted
Renjith Pillai
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.
July 6, 2013

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" ;

0 votes
Manthan March 4, 2020

Is this formula for defect turnaround of defect age?

0 votes
Rumit Patel July 25, 2013

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

Archana Devi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 3, 2018

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?

0 votes
Rumit Patel July 25, 2013
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

Suggest an answer

Log in or Sign up to answer