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

[Ashley Eastman]

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! 

[Oskars Laganovskis · Accepted solution]

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

[Ashley Eastman]

Hi Oskars! 

This worked great. Thank you so much for your assistance