Forums

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

Can I get historical Sprint data through JQL?

Asokan Manickavasagam June 10, 2024

We have 12 Jira projects and scrum boards.

I have used Sprint Health and Sprint burn down widgets to create Dashboards that shows the Active sprint details of those 12 projects.

Is there a way to get historical Sprint (for ex: last 6 closed sprints) information through JQLs, so I can pull the data into MS Excel online through Jira Cloud App for Excel, and generate Pivots/Reports in the Excel?

 

The idea is to build a Dashboard with Sprint metrics for all 12 projects in a single view/page. 

2 answers

11 votes
Vasyl Krokha (Broken Build)
Atlassian Partner
June 10, 2024

Hi, @Asokan Manickavasagam

Jira doesn't provide such capability, but there is Agile Reports and Gadgets app, which has cross-team Velocity chart allowing you to see several teams on one chart:

Velocity chart_ Scrum boards (1).png

And also you can export the chart data to .csv:

Monosnap Image 2024-06-10 11-31-27.png

Or even generate a Live Data link to pull date to your sheets automatically:

Monosnap Image 2024-06-10 11-34-21.png

Hope you find my answer useful!

Asokan Manickavasagam June 10, 2024

Thanks for sharing the details @Vasyl Krokha (Broken Build) 

Due to other factors we are not planning to get yours or any other 3rd Party app at this point. 

Vasyl Krokha (Broken Build)
Atlassian Partner
June 10, 2024

@Asokan Manickavasagam gotcha.

Just in case you are not planning to use 3d-party apps due to security and compliance reasons, we are Cloud Fortified, meaning we meet Atlassian requirements for safety and data protection.

That's why our apps are used by:

Monosnap Agile Reports and Gadgets_ Velocity Chart, Burnup_Burndown Chart in Jira _ Broken Build 2024-06-10 13-56-57.png

Whenever your factors change, please do not hesitate to book a demo with us to create a PoC according to your current objectives. 


0 votes
YY Brother
Community Champion
June 10, 2024

Hi @Asokan Manickavasagam 

Welcome to our Community.

I think this Sprint Reviewer Pro app is just for your requirement.

Key Features:

📊 Comprehensive Sprint Tracking: Monitor up to 50 sprints per board with detailed metrics.

📈 Advanced Progress Metrics: Track sprint progress using both Story Points and Time.

📋 Issue Counts by Status: Get a clear view of issue distribution across different status categories.

📁 CSV Data Export: Export sprint data for further analysis.

Hope it helps & thanks,
YY哥

Suggest an answer

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

Atlassian Community Events