Can I get historical Sprint data through JQL?

[Asokan Manickavasagam]

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. 

[Vasyl Krokha _Broken Build_]

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:

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

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

Hope you find my answer useful!

[Asokan Manickavasagam]

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_]

@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:



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

[YY Brother]

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哥