Can I get historical Sprint data through JQL?

Question

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.

Yong Yang · Answer

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哥

Vasyl Krokha _Broken Build_ · Answer

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

Asokan Manickavasagam · Answer

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.