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?
The following custom formula calculates the average time difference between two date fields:
NOT IsEmpty([Measures].[Issue resolution date])
NOT IsEmpty([Measures].[Test completed date])
DateDiffDays([Measures].[Issue resolution date],[Measures].[Test completed date])
Janis, eazyBI support