Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Is there any way to filter by the last 3 closed sprints?

Vic Kharitonov
Vic Kharitonov
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!
Get involved
January 17, 2019

Is there any way to filter by the last 3 closed sprints using only JQL? Not considering power querry as a solution. Or maybe there are plans to introduce such function that will allow  to see the last spints.

Thank you in advance.   

Answer
Watch
Like # people like this
21616 views

2 answers

1 accepted

12 votes
Answer accepted
Brittany Wispell
Brittany Wispell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 6, 2019

Hey @Vic Kharitonov

You could try using the below in JQL. If you are doing 2 week sprints you can update the resolved date to be specific to the # of weeks for the 3 closed sprints. 

sprint in closedSprints() and resolved >= -8w

 Hope this helps. Let me know if you have any other questions!

View More Comments
Rob van den Belt
Rob van den Belt
Contributor
February 20, 2019

Great! Simple and effective!

Like
Brittany Wispell
Brittany Wispell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 28, 2019

Wonderful! 

If this answers your question would you please hit the Accept answer next to the vote button.

Much appreciated! 

Like
Fernando Trindade
Fernando Trindade
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!
Get involved
March 30, 2023

It won't show rolled over issues... :/

Like • # people like this
Andy_Swift
Andy_Swift
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!
Get involved
April 17, 2023

Unless I'm getting it wrong. 

It also only works at the beginning of a new sprint...
It starts to bring in issues from Sprint -4 

As the open sprint moves into its second week.

😕 

Like • Alexander Bondarev likes this
Reply
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events