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?
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Currently, it can be achieved via add-ons
Scriptrunner
issueFunction in dateCompare("", "resolutionDate > dueDate")
Ref here
In Jira, there is a support request on this
https://jira.atlassian.com/browse/JRACLOUD-20727
Thanks,
Pramodh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.