using EasyBI, I am trying to report the number of issues that get closed within a custom number of days from creation date. we do not use due date, but we do use resolution date.
See Example here:
5 issues were created on November 1, with the following resolution dates:
2 Resolved Nov 3 (2 days after create)
2 resolved Nov 5 (4 days after create)
1 resolved Nov 10 (9 days after create)
Assuming that I want to see all issues closed within 7 days of the creation date (Considered “In Time”, I hope to see a table like below: (Specifically focusing on returning results for the 3rd column)
In this case, you could define a new calculated member (with Integer formatting) for “Measures” dimension which would do this calculation
Try this code:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])
AND
[Measures].[Issues created]>0
AND
Datediffdays(
DateWithoutTime([Measures].[Issue created date]),
DateWithoutTime([Measures].[Issue resolution date])
)<=7
)
)
)
Later you could define another new calculated measure (with % formatting) to calculate the Close Rate (from the measures Issues created and the measure from the previous step)