Hi,
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)
See also the attachment below.
Martins / eazyBI support
