Hi,
Can you please help me with how can I get a list of issues that are older than 12 working days and still not been resolved?
Thanks,
Peter
Hi,
In this case, you could try defining a new user-defined calculated member in "Measures" dimension using the following code:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
AND
[Measures].[Issues due]>0
AND
Datediffworkdays(
DatewithoutTime(
[Issue].CurrentHierarchyMember.get('Created at')),
DateWithoutTime(now())
)>12
)
)
)
Please reach out to eazyBI support if you have further questions about this!
Martins / eazyBI support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.