The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.