Forums

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

How write jql query for last 4 sprint data.?

Devops
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!
August 31, 2020

How write jql query for last 4 sprint data, which I can use in jira board and get proper velocity report??? P

Please help me guys

2 answers

1 vote
Devops
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!
September 3, 2020

Could you help me with jql query for last 4 sprint? 

ScrumPoint October 15, 2020

JQL:

sprint in (sprint#,sprint#,sprint#,sprint#)

for instance

sprint in (8601,8602,8603,8604) 

The sprint numbers can be found in the url bar of the scrum boards you use and look something like this - View=1249&sprint=8629

or use the advanced search in JQL

and type: sprint in ("YourSprintName") and it will auto convert it into the correct sprint number.

 

Kind regards

0 votes
Sudarshan
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.
August 31, 2020

Hello,

Jira by default provides a Velocity report for the last 7 sprints 
https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-velocity-chart/

Please define what is a "Proper Velocity report???"

However, If I understand your question, sometimes the product complexity changes at shorter duration and there could be a need to only show the last 4 or 5 sprint data. there are some add-on available  check this - https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

Else the best way, would be to check the Sprint report for the last 4 sprints  and calculate your required data. - https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-sprint-report/

Leo
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!
September 29, 2021

I think the author wants to calculate the average velocity over the past X sprints?

Its surprising that this isn't possible to do out of the box, its such a fundamental thing to do when working with e.g. Scrum!

This is pretty much telling me to grab a pen and paper... 

Like # people like this

Suggest an answer

Log in or Sign up to answer