How to implement filters and KPI for tasks closed on time. Could you please support?

[Youssef EZZAHDAOUI]

How to implement filters and KPI for tasks closed on time. Could you please support?

[Jaime Escribano (knowmad mood)]

Hi @Youssef EZZAHDAOUI and welcome to the community 😊

I'm afraid that out of the box, the function that you are trying to achieve is not possible. This is because JQL does not support field comparisons.

This leads to operations such as "Assignee is different than Informer" or "Due date is later than End date" not being supported.

You can use Scriptrunner to achieve this functionality though in case you are open to it. (See this post Solved: How to filter to issues that were resolved after t...)

Another option would be creating an Automation. In this Automation you would use the following pseudocode:

- Trigger: When the resolution field is changed (value added)

- Conditional - Smart value comparisson:

         - If {{issue.due date}} is greater than {{issue.resolution date}}

         - Then add label to issue - ClosedOnTime

Then you could create a JQL (and a filter )searching for "label = ClosedOnTime"

Let me know if you need an example of the automation!

Regards,

Jaime Escribano

[Youssef EZZAHDAOUI]

HI @Jaime Escribano (knowmad mood) Thank you for your insights.

I will try your proposal and see if it will work :)

Thanks a lot

Best regards,

Youssef Ezzahdaoui

[Jaime Escribano (knowmad mood)]

Do let me know how that went! 

If you have success, feel free to mark my answer as accepted so it can help other members of the community whith similar questions 😊