Sprint metrics - automated dashboard

unknown

Hi there

I'm looking to monitor the 3 metrics below across 10 Scrum teams: 

• Number of User Stories open at a time per Sprint
• Number of incomplete User Stories per Sprint
• % of Story points complete at Sprint end 

Ideally this should be automated into a Dashboard view. And generate a rolling average for each metric for each Scrum team. 

Any suggestions on filters, dashboard gadgets, and generally the best approach?

Thanks

Bill Sheboy

Hi @[deleted] -- Welcome to the Atlassian Community!

I do not believe you can get any of those as a plain number value (or rolling average value) with out of the box Jira.  There are built-in reports and charts from which you could view and gather the information.

If you want those specific measures, you could:

• Investigate reporting options in marketplace for purchase,
• Use the Excel plug-in (or Google sheets) to pull data regularly and build your own reports,
• Use the REST API to pull the data into another reporting tool, or
• Add some custom fields or properties and use automation rules to gather the information and sprint event triggers.

If for the "Number of User Stories open at a time per Sprint" you mean the WIP level over time, you can see that on a Cumulative Flow Diagram (built-in chart) by adding all of the team's information to a single, Classic project Kanban board.  Remember to use that board as view-only (no updates) if you try that route.

Best regards,

Bill