What is the best way to get number of done tickets within a year?

[Silvia Saric]

Hi all,

Our board of directors want to see the number of completed tickets for 2021, 2022 and 2023. The states I want to include are "Released" (deployed tickets) and "Done" (configured tickets).

I am not the best JQL:er in the world so I have been creating separate filters for each state but it is a hassle, so I ask the experts here instead. What is the best way forward?

Here is an example of what I have been messing around with:

project = "Salesforce CC" AND status was in ("Ready for Release") before "2024/01/01" after "2022/12/31"

project = "Salesforce CC" AND status was in ("Done") before "2024/01/01" after "2022/12/31"

I chose "Ready for Release" instead of "Released" because obviously, all tickets that are released will be there, even since before the date interval. I think I face the same problem with "Done" as there is no state I can "catch" those tickets in before transitioning to "Done" from "Testing Done". So now I am stuck.

Thanks in advance!
Kitty

[Ignacio Aredez GenAI Expert · Accepted solution]

To simplify your JQL queries for capturing "Released" and "Done" tickets across 2021, 2022, and 2023 in a single, more concise query, you can combine the conditions using OR and adjust the date filters to cover each year. Here's a streamlined approach:

project = "Salesforce CC" AND (
(status was in ("Ready for Release", "Done") DURING ("2021/01/01", "2021/12/31")) OR
(status was in ("Ready for Release", "Done") DURING ("2022/01/01", "2022/12/31")) OR
(status was in ("Ready for Release", "Done") DURING ("2023/01/01", "2023/12/31"))
)

 This query assumes:

You're looking for tickets that were in either the "Ready for Release" or "Done" status during the specified periods.

It combines the checks for both statuses across each year within a single query, reducing the complexity and number of filters you need to manage.

If your workflow allows "Released" tickets to bypass the "Ready for Release" status directly, you may need to adjust the query accordingly. However, this should provide a solid foundation for your reporting needs.

[Silvia Saric]

Thank you Ignacio! This did the trick. I need the filter to show one year at a time so this part of the query did suffice for e.g. 2023:

project = "Salesforce CC" AND ((status was in ("Ready for Release", "Done") DURING ("2023/01/01", "2023/12/31")))

Our workflow does not allow "Released" tickets to bypass the "Ready for Release" status directly so this was excellent.

[Ignacio Aredez GenAI Expert]

I am glad to have helped you if you vote me the answer and give me like I would appreciate it.