Hi I wanted to know if it was possible to filter only the issues that has a due date that comes before the completion date. We have a completion date field called Date Complete and use the default field for due date. I want to create a table that will just show me the issues that were late.
Hi @Hiro
Please check this demo report Issues due and overdue - Issues - Jira Demo - eazyBI
It has a calculated measure “overdue issues in period” that shows issues that were resolved past due date.
And another one - “overdue issues” that would work if you don’t add a “Time” dimension to the report.
You can copy/paste formulas where you replace the “Resolved at” with “Date Complete”.
But first, make sure that you imported your custom field “Date complete” with “measure” and “property” checkboxes selected in import options page.
https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields
Martins / eazyBI