Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,683
Community Members
 
Community Events
168
Community Groups

EazyBI, I want to create a measure for issues which do not have a due date yet

Hello! 

I am interested in creating a measure that shows tickets that are open and do not have a due date yet. Our JIRA project's due date is a custom field and sometimes employees do not add a due date to the ticket. I want to show those tickets without due dates. Thank you! 

1 answer

1 accepted

Hi @Ashley Eastman,

Open issues without a due date would have both fields empty - "Resolved at" and "Due date".
​Most probably, you want to identify recently created issues without the due date. Therefore you might add the Time dimension to the page filter.


The expression to check if the issue complies with the current page selection but is still open/unresolved and without a due date might be as follows.

Nonzero(
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--condition 1 - compliant to the page selection
[Measures].[Issues created]>0
AND
--condition 2 - open/unresolved issue
IsEmpty([Issue].CurrentMember.Get('Resolved at'))
AND
--condition 3 - missing due date
IsEmpty([Issue].CurrentMember.Get('Due date'))
),
[Measures].[Issues created]
))

You might use this measure to filter rows or drill through issues to find the relevant ones.

 Regards,

Oskars / Support@eazyBI.com

Hi Oskars! 

This worked great. Thank you so much for your assistance

Suggest an answer

Log in or Sign up to answer