How to calculate total duration of a ticket in particular custom field.

[Suseendran Rajkumar]

Is this possible in custom field or scripted field.

Calculate the time duration of ticket

calculation is start when  ticket is entered to open status close when ticket entered to closed status.

kindly suggest their is any alternate way to calculate time duration id ticket.

[Suseendran Rajkumar · Accepted solution]

Hi,

Time in status Plugin which i used to for this issue.

Time in Status | Atlassian Marketplace

[Gizem Gökçe _OBSS_]

Hello Suseendran,

As the Product Manager for Time in Status, I am delighted to hear that you are benefiting from our product. If you have any comments, suggestions or questions, please feel free to contact me at plugin@obss.tech

I'll be happy to help!

Update on May 9th, 2024: Time in Status by OBSS was recently rebranded as Timepiece. It is still the same capable app with the same dedicated team behind it. The answer below mentions the app as "Time in Status" but you can find the app in the marketplace as "Timepiece (formerly Time in Status)". 

[Valeriia_Havrylenko_SaaSJet]

Hello @Suseendran Rajkumar 

As an alternative, you can try Time in Status for Jira Data Center developed by my team. It generates 3 types of status time reports.

During 2023 we did not provide Data Center version, but now we are available.
I'm sure that our add-on will help you find bottlenecks.


>> Try it free for 30 days.

🔥 Exciting insights and powerful results in your work!

[Sakina Baghirova · Accepted solution]

Hi, @Suseendran Rajkumar 

Can you try something like this?

import com.atlassian.jira.component.ComponentAccessor

def createdDate= issue.created as Date
def resolutionDate= issue.resolutionDate as Date

def durationMillis = resolutionDate.getTime() - createdDate.getTime()
def duration = (durationMillis/1000).toLong()

[Suseendran Rajkumar]

Hi, @Sakina Baghirova ,

Thank you.

[Sakina Baghirova]

as Scripted Field

[Suseendran Rajkumar]

Hi @Sakina Baghirova

I found another way to calculate total duration of Ticket.

Thanks for suggesting script it also need full.

[Mehmet A _Bloompeak_]

Hi @Suseendran Rajkumar

As an alternative, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Time in Status for Each Issue report. You can filter by Issue Type, Status, Assignee, Created fields or by typing your own JQL(using "Switch to JQL" button). For further details, you can have a look at Status Time Reports How to Videos.

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, resolution time, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

Hope it helps.

[Mariana_Pryshliak_SaaSJet]

Hello @Suseendran Rajkumar 

It's a popular request in the community and I hope you find the solution.

[Suseendran Rajkumar]

Hi @Mariana_Pryshliak_SaaSJet 

Yes i found a solution with a plugin.

Its wonder to explore new thing in jira.

[PNG Jira Lead]

hi @Suseendran Rajkumar 

could you share the plugin that helped you, that other members might benefit from the same insight?

Thanks in advance,

-Darren