Date Calculation In Jira Cloud

[Karthik Mohan]

I would like to write a script which calclautes the differnce between two date fields and display the result as number of days in a custom text field on the jira cloud.

Field 1 : start date (Date Picker)

Field 2 : end date (Date Picker)

Field 3 . total number of days. (Text Field)

Expected result:

Filed 3 = field 2 - field 1

I have tried script runner as well but there are limitation on using script runner on the cloud. i was not able to import the issue class package on the cloud.

is there any other work around for this ?

[somethingblue · Accepted solution]

Hi Karthik,

You may have luck with another add-on such as EazyBI as discussed in the Communities post Custom calculated field(s).  Here is the response from EazyBI support in that ticket:

If Field 1 and Field 2 are imported in eazyBI, you can create a new calculated measure with arithmetical calculation formula:

[Measures].[Field 1] - [Measures].[Field 2]

In case, if Field 2 is empty, the result will be a value from Field 1. Add this measure in columns.

If these custom fields are imported as measures, you can use measures "Field 1 created" and "Field 2 created" (or for due and resolved issus) to get them rolled-up for projects or other dimensions. 

To get the total for each column, use eazyBI option Total.

For more specific answer please write to support@eazybi.com and describe what kind of custom fields they are, how they are imported and the report you want to build.

Hopefully that helps!

Cheers,

Branden