Eazybi - Get issues which are still open longer than 12 working days

Peter Juhasz November 16, 2017

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

2 answers

0 votes
Sir Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 6, 2018

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

0 votes
Manuel.Boira October 24, 2018

I vote for this.

BR

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events