How to create a year-end report for assignees

[cherie_woodward]

I'm trying to create a report that sums up issues completed/done by assignee in 2021.

I have used several JQL queries, including:

project = "project" AND issuetype = <type> AND assignee = <assignee number> AND "Start date[2021-01-01]"  <= "End date[2021-12-30]"

But I still can't create a report for a previous year's worth of issues for an assignee.

I looked at Atlassian documentation and tutorials. I searched stack overflow.

What filter would produce the results I'm looking for?

[Garrett McCreery · Accepted solution]

Hi Cherie,

instead of start and end date, you should use resolved. You can also use the startOfYear, endOfYear with -1 as the parameter for last year. You can use dates if you want as well, but these functions are handy.

resolved > startOfYear(-1) AND resolved < endOfYear(-1) ORDER BY resolved ASC

Hope this helps you.

[cherie_woodward]

I REALLY appreciate the year variables, @Garrett McCreery . I managed to get those to work in other queries.

Unfortunately, I had to stop pursuing this query as three of the users are now inactive in our system. 

I'll go up the food chain to get this data.

THANKS!