Is there a filter to show me the tickets completed within a date range?

[Katie Gates Quiroga]

I am looking to show how many tickets were completed by month  YoY for the last 2 years on a specific project.  I don't care when the tickets were created.  I am just looking for how many tickets and how many points were completed each month. 

x # of points completed in January 22

X # of tickets completed in January 22

or a list of tickets completed in January 2022

[Mark Higgins]

Hi Katie,

There are a number of functions that, I believe, can assist here, such as startofmonth().

You can create a query such as startmonth(-24) so you get all tickets for the last 24 months.

In my instance, you can even use AI and type in what you want, like and then the JQL appears.

You then save that to Excel and create month functions on the data.

Hope that helps

Cheers

Mark