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.
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.
[Measures].[Issue resolution date],
[Measures].[Issue End Date],
[Measures].[Issue Begin Date]
Elita from support@eazyBI.com