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.
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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哥
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.