How to define a new measure using new custom defined JIRA field

Hi, We have a custom defined field in JIRA and we’ve pulled that field into eazyBI - say it’s test completed.

We need to define a new measure as average of the difference in between the test completed and resolved time for all the JIRA issues which have these two fields as non-empty.

Can somebody please help in how to go about the same?

Hi,

The following custom formula calculates the average time difference between two date fields:

Avg(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  NOT IsEmpty([Measures].[Issue resolution date])
  AND
  NOT IsEmpty([Measures].[Test completed date])
  AND
   ([Measures].[Issues resolved],
   [Time].CurrentHierarchy.DefaultMember)>0
  ),
  DateDiffDays([Measures].[Issue resolution date],[Measures].[Test completed date])
)

Kindly,
Janis, eazyBI support