Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a year-end report for assignees

cherie.woodward
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 23, 2022

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?

1 answer

1 accepted

0 votes
Answer accepted
Garrett McCreery
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 23, 2022

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'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 24, 2022

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!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events