Is there a way to calculate how long of a issue has been opened and assign the value to a field?

[Licenses]

Like to check how long of each issue has been opened and show the day/time counts on a new custom field like "Age".

Is there a way to do that?

Thanks!

[Trudy Claspill]

Hello @Licenses 

Welcome to the Atlassian community.

Jira v9.12 does not have a native custom field that stores time as a duration.

If you have the Automation for Jira feature available to you (native in Data Center licensed instance) you could use an Automation Rule to get the duration difference between now() and createddate and store that in a field, but the value may not be in a pretty format such as 1d 3h 14m.

More information on that feature can be found in this documentation:

https://confluence.atlassian.com/automation0902/jira-data-center-automation-1431247381.html

If you are running on a Server license the Automation for Jira feature is not automatically included and would have needed to be installed by your Jira Administrators. It also may not have all the same functionality available in it as the feature set for a Data Center license.

If you are going to use Automation for Jira you will have to decide how often you want to update that "Age" field, and set the rule to trigger accordingly.

There are also third party apps available from the Atlassian Marketplace that can provide calculated fields for Time in Status and other duration types of metrics. However, if you are truly running under a Server license, support for Server has been ended and the app vendors no longer support getting new app licenses for Server environments. You would have to upgrade to a Data Center license to get a new app license.

Let me know if you have additional questions on the information I provided.

[John Funk]

Hi Licenses - Welcome to the Atlassian Community!

There are a few ways to do this. One is to use a third-party app for Time In Status. There are several good ones at low cost or maybe even free. 

The other way is create a custom number field and default it to 0. Then create an automation rule to increment the value of the field each day with a Scheduled trigger that runs in the middle of the night. Then each morning when you start work, you will know how long the work item has been open. 

[Brant Schroeder]

@Licenses welcome to the community

To add on what @John Funk and @Trudy Claspill have shared you can use Jira Service Management it has SLAs built in that will track this for you.  It might be cheaper than a third-party app or automation depending on how many users need to see the SLA information.  It also has built in reports that you can use to track how well you are doing on the SLAs.  So if you have a metric that you would like to meet, example: all bugs need to be closed within 48hrs, it will let you know how many work items have breached that SLA.