Custom calculated field(s)

[Sherri Netherby-Cox]

Hi I am trying to do the following either in JIRA itself or using eazyBI

Take two custom fields:

Field1  Field2  Total

2          1          1 (if there is an entry in field2 subtract it from field1)

2                      2   (if there is no entry in field2 carry over the total from field1)

Sum Sum Sum

Can anybody help me here ?

Thx!!!

[Brandon Oakley]

This can do calculations...

https://marketplace.atlassian.com/plugins/com.mumosystems.abacus/cloud/overview

[eazyBI Support]

Hi, Sherri!

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.

Ilze,

eazyBI support consultant

[Steven F Behnke]

Can I ask, you're looking for this to be data within JIRA, the results of aforementioned fields calculate to obtain a value for a third field? I ask because the concept of scripted fields isn't very possible in JIRA Cloud.