Time calculations on custom field

Hello All,

We are creating a report to visualize the total outage duration per month/ quarter etc, for issues resolved in that duration.
Initially, it was calculated based on the effort logged for the Jira issue but with updated requirements, it needs be a difference of ‘End Date’ and ‘Begin Date’.
We created a custom measure, and it calculates the value with expected result on the issue level but does not sum it on the month/ quarter level.
Can someone please help us with this?

Thanks in advance.

-Gaurav

Hi @Gaurav1008

If Time is selected in Rows and you would like to calculate the sum of two date differences for all issues, I recommend using Descendants() function.

You might want to try the below formula and see if it now returns the expected results for the selected time period.

Sum(
    Filter(
        Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
       [Measures].[Issue resolution date],
       [Time].CurrentHierarchyMember)
    ),
 DateDiffDays(
 [Measures].[Issue End Date],
 [Measures].[Issue Begin Date]
 )  
)

Best wishes,

Elita from support@eazyBI.com