How can I make a custom calculated field for number of days since created date.

[Zaldy Parian]

I wanted to create a custom field that will calculate the number of days outstanding since the issue/bug was created. And if possible, excluding the weekends and holidays. This is important in our company as we check the turnaround time of the issue/bug closure time with the standard level of agreement (SLA).

[Tuncay Senturk]

You can use Enhancer Plugin for Jira

It has a couple of Time custom fields.

• Time Between custom field calculates time between two status, and display the result according to the selected calendar. However, it only displays value when the issue arrives to final status
• Time Tracker custom field can calculate time like Time Between, but it does not wait for final status. Also it can sum time in subtasks as well.

Best

[Faisal Shamim]

How can I do this in JSD @Alex Christensen  , I am using JSD cloud and want to know if its possible to do some calculation on custom field ? Thanks in advance 

[Pronto Software]

Hi @Faisal Shamim

I can't see any special JSD Custom Field types that include calculation capability.

As far as I can work out the JSD built-in capability could be achieved with Project Automation. Note: the calculation would occur after the customer creates the request.

There are a number of add-on apps that provide this capability, we use Jira Misc Workflow Extensions and Extensions for JSD.

Good luck,

Peter Q

[Alex Christensen]

If you aren't using Jira Service Desk, this is something built-in in JSD, so if that's a possible option for you to evaluate, I'd definitely consider it. More details about Service Desk here.

Other than Jira Service Desk, there's no way to do this by default. You will need an add-on to achieve this. Some suggestions I have if you're on Jira Server (I don't know any for Jira Cloud off the top of my head):

• Jira Misc Custom Fields introduces a Calculated Number or Text Field type. You can write some code to return what you need.
• ScriptRunner allows you to create scripted fields, so you could create a script that returns what you need, as well.

[Zaldy Parian]

I guess I'll have to do extract to excel for now, and add a formula to calculate the elapsed time. :-(

[Aron Gombas _Midori_]

@Zaldy Parian  if the Excel route is an option for you, then check out this article (it saves you manually creating the formula every time). 

This example has 2 fields in the right that calculate the duration between 2 events, so you can use this as inspiration:

[Tuncay Senturk]

Hi @Aron Gombas _Midori_ 

As far as I know, you're violating "No necroposting" rule which is mentioned here: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-vendors/ba-p/689723

[Aron Gombas _Midori_]

Oh, it seems you are right 😕

[Tuncay Senturk]

Yeah, I also noticed those guidelines very late :)