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!
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.
--condition 1 - compliant to the page selection
--condition 2 - open/unresolved issue
--condition 3 - missing due date
You might use this measure to filter rows or drill through issues to find the relevant ones.
Oskars / Support@eazyBI.com