It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Peter Juhasz Nov 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

I vote for this.

BR

0 votes
Mārtiņš Vanags Nov 06, 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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Marketplace Apps & Integrations

Join our webinar: “Asset Management: The Role of Context in ITSM” with Atlassian & Riada

  Hi Atlassian Community! This is Teresa from the Jira Service Desk team. On June 19th, I’ll be hosting a webinar “Asset Management: The Role of Context in ITSM” with Atlassian Partne...

151 views 2 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you