Sprint reports at scale for rollover to help improve planning and delivery flow

[Nicolae Victor Rusu]

Hi team, I am looking for a bit of guidance as to how to build a dashboard that visualises Sprint status reports (completed issues, issues not completed, issues removed from sprint, issues added after sprint start) at scale. 

In a space (p.k.a project) I have 10 Feature teams operating on Scrum boards. Rather than visualising team by team the sprint report is there a way to see this in 1-stop-shop aggregated view which ideally would allow to click into each Team name and see all the details 

I think I'm getting quite close with the 🔍 Sprint rollover report essentials: Identify pat... - Atlassian Community however I fail to identify a way to create a visual that will allow me to see by team and by issues 

TL;DR a way to view the data from the Sprint Report but across all teams in a space 

[Alexey Pavlenko _App Developer_]

Hi @Nicolae Victor Rusu ,

You can use the app I developed - Multi-team Scrum Metrics & Retrospectives.

With it, you can track

• Completed issues = Completed Scope
• issues not completed = Uncompleted Scope
• issues removed from sprint = Removed Scope
• issues added after sprint start = Added Scope

metrics or any other custom metrics constructed via JQL for up to 4 teams over several sprints, months, quarters, half-years, or years in a single view. The limitation of 4 teams was set on purpose for the sake of UX and performance. I'd recommend using 3 gadgets next to each other on a dashboard. However, if it's a must have for you to have 10 teams in one gadget - I can implement it for you in 1 day.

Periods = Sprints, Number of Periods = 2, Team Boards = 3, Analyzing and retrospecting Uncompleted Scope:

Periods = Sprints, Number of Periods = 2, Team Boards = 2, Analyzing all periods:

Period = Sprints, Number of Periods =2, Team Boards = 3, Analyzing one of the sprints:

Period = Years, Number of Periods = 2, Team Boards = 2:

Best regards,
Alexey

[Bill Sheboy]

Hi @Nicolae Victor Rusu 

Short answer: the built-in sprint report only displays for a specific board within a space.  To see multiple boards (e.g., for different teams' boards) on something like a dashboard, a marketplace app or addon dashboard gadgets would be required.

The reason is much of the information you describe is only available by checking the work item histories.  This is apparently what the built-in sprint report does with application code or internal endpoints.  There is no built-in dashboard gadget which can do this generically for any board.  And, there is an old, deprecated Greenhopper REST API endpoint to get the sprint report data, but no easy way to show that on a dashboard (even if it wasn't deprecated).

Kind regards,
Bill

[Nicolae Victor Rusu]

Thank you Bill for taking a look at my request, much appreciated. I'll leave the question open in the hope that someone might have found a way to 'hack it' I have seen via rich filters there's a lot of unique dashboards that can be build so will keep trying in parallel. 

This one in particular almost gives me that view I'm after but NOT 100% there yet 🔍 Sprint rollover report essentials: Identify pat... - Atlassian Community

[Kavitha Chandrasekaran]

Hi @Nicolae Victor Rusu You could try EazyBI or Atlassian Analytics. These have a lot more granular/meta data and you should be able to generate the report you are looking for. I have done it in EazyBI sometime back.  

[Nicolae Victor Rusu]

Thank you this is useful insight, I don't have access to EazyBI, however Atlassian Analytics could be the solution. Do you have by any chance a guide on 'how to build' ?

[Marlene Kegel - codefortynine]

Hello @Nicolae Victor Rusu,

I’m Marlene from the team working on Quick Filters for Jira Dashboards.

There are several Marketplace apps that can help build Jira dashboards building cross-team dashboards.

With Quick Filters for Jira Dashboards, for example, you can add a Quick Controller gadget that lets you filter all other Quick gadgets on the dashboard by feature team or any other value that’s filterable via JQL.

You can also aggregate Jira number fields such as story points, which can be useful when tracking sprint progress across teams.

[Iryna Komarnitska_SaaSJet_]

Hi @Nicolae Victor Rusu ,

I see Atlassian Analytics has already been recommended to you — and I agree, it’s a really handy tool. Atlassian’s documentation also shows what charts are included in their multi-sprint templates.

That said, if I remember correctly, Analytics templates mostly focus on charts. In your case (completed issues, not completed, removed from sprint, added after sprint start), you’ll probably need issue lists, not just visualizations. I’m also not sure how well this can be implemented with custom Analytics gadgets in a grid/table format.

As an alternative, I’d recommend the Sprint Report from Time in Status (developed by my team). Right now, it supports summary reports for individual sprints (both active and completed). Multi-sprint reporting isn’t available yet.

The good news is that we’re planning an update to the Sprint Report next week: it will include a detailed breakdown of each sprint metric, so you’ll be able to view completed issues, not completed, removed, added after sprint start, etc. in a clear text/list format.

Hope this helps — happy to share more details if you need.

[Danut M _StonikByte_]

Salut @Nicolae Victor Rusu,

Indeed, visualizing sprint progress through the Jira's Sprint Report is not so handy when you have multiple teams.

My advice is to create custom Jira dashboards with the necessary gadgets for visualizing the team progress. You could create a dashboard for one team, and then clone it for the other teams. This way you can easily switch between dashboards/teams.

This approach is described in this article: https://community.atlassian.com/forums/App-Central-articles/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694 

  

Jira offers several useful built-in gadgets that you could use for this, such as Sprint Burndown, Sprint Health, and Two-Dimensional Filter Statistics. But if it happens to have our Great Gadgets plugin installed, you can easily create powerful dashboards to track per-team progress as well as overall cross-team performance in real-time.

See also https://community.atlassian.com/forums/App-Central-articles/9-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063

Danut.