Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,852
Community Members
 
Community Events
165
Community Groups

How to create a year-end report for assignees

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

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.

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
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

147 views 2 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you