Tracking Issues Completed On Time

Question

Trying to assist a team tracking their issue under under Epics as "Action Items Completed On Time." I'd like to be able to compare the Due Date field with the date the ticket Status changed to Done.

I was thinking if using a JQL such as (resolutiondate <= "Due Date") but there seems to be limited to making another comparison to another function or fixed date.

Is there a way to query this with JIRA out-of-box?

Karolina Wons_SaaSJet · Answer

Hello @Henry Chad Apale

If you haven't found a JQL solution yet, as an alternative, you can try Time in Status for Jira Cloud. It generates a Status Entrance Date report that shows the date an issue has entered each of the statuses.

So you can compare the Due Date field with the date the ticket Status changed to Done easily.

This add-on is developed by my SaaSJet team and is free for using up to 10 users. So let me know if you have any additional questions.

Hope it helps.

Fabian Lim · Answer

Hi @Henry Chad Apale

You may want to consider some reporting plugins as well such as eazybi.

This is an example: https://community.eazybi.com/t/show-jiras-that-have-passed-the-due-date-overdue-items/439

There are a bunch of other reporting plugins that may have a similar functionality such as structure which has formulas.

Regards

Pramodh M · Answer

Hi @Henry Chad Apale

Currently, it can be achieved via add-ons

Scriptrunner

issueFunction in dateCompare("", "resolutionDate > dueDate")

https://community.atlassian.com/t5/Jira-questions/JQL-for-issue-resolved-after-Due-date/qaq-p/1374643

Ref here

https://community.atlassian.com/t5/Jira-questions/JQL-Query-to-Find-Issues-Resolved-On-or-Before-Due-Date/qaq-p/988137

In Jira, there is a support request on this

https://jira.atlassian.com/browse/JRACLOUD-20727

Thanks,
Pramodh