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