Aggregate metrics from 10+ JIRA boards

[Alina]

Hi Atlassian community!

My global team consists of 10+ squads, meaning 10+ JIRA boards. My question is, how can I create a report presenting aggregate metrics for all these 10+ squads? For example, I can go to one squad's JIRA board and get a velocity report, but how can I get ALL the 10+ velocity reports together?

In more detail, I also need story points completed by category (research, new product development, maintenance, etc.) reported for each JIRA board. Again, I can run such a report individually for each board, but I would need to do that manually and it seems extremely time-consuming and inefficient.

I was curious if anyone else here ever ran into a similar issue, and how you handled it. One suggestion I received was to build a Jupyter notebook that would extract the metrics from JIRA...is that even possible?

Thank you so much in advance!

[Lauma Cīrule · Accepted solution]

Hi @Alina,

If you would be interested in a third-party app for reporting, you can check out eazyBI. 

Here is a demo dashboard with various Sprint reports, including a velocity chart for several projects and boards (filtered in Pages): https://eazybi.com/accounts/1000/dashboards/5956-sprints-overview.

Let me know if you have further questions regarding eazyBI!
Lauma / support@eazybi.com

[Alina]

Thank you so much, Lauma! The demo dashboard looks great, and it does have the capability I was looking for (an aggregate velocity chart or table). I will present this as an option to our stakeholders next week.

Thanks,

Alina

[Patty Land · Accepted solution]

You've got a couple options, for a velocity chart, you'd definitely want to leverage the built in report in the boards, and remember Jira boards are just filters of Jira issues; so, if you have 10 teams, each of whom's board is probably filtered something like project = ABC and issuetype in (Epic, Story) and Squad = A, you'd simply create another board which you filter without the squad: project = ABC and issuetype in (Epic, Story). The sprints of each board will all filter into this aggregated board, because the issues do. You can either sync sprints across the squads and see a single velocity chart per sprint, or you can name each sprint for each squad to still be able to tell them apart in the aggregate board.

For story points by category, this would be best suited for a dashboard gadget, such as two dimensional filter statistics. This can be done with the basic gadget, but if you have budget to consider plugins, Rich Filters for Jira Dashboards is excellent for beefing up your reporting, Agile or otherwise. With rich filters, I can create a bar chart of story points completed per squad per sprint. With the standard two dimensional filter statistics gadget, I can pull in squad by category, with my value as story points, and the underlying filter is sprint = 12345 (enter a new gadget for each sprint ID, or you can show all the past sprints together and not have to maintain updating the gadget.

[Alina]

Thank you so much, Patty!

1. That's a great idea, creating an aggregate board. The velocity chart of that aggregate board is going to display all sprints from all boards. This solves part of my problem.

2. I was just playing around with the two-dimensional filter yesterday. It's good, but it's not enough. I need three-dimensional statistics (by assignee, by story points, and by tech category); do you know if Rich Filters has a three-dimensional filter? You mentioned "With rich filters, I can create a bar chart of story points completed per squad per sprint." I need a bar chart of story points completed per assignee per sprint, broken down by tech category (for example: Alex completed 21 new product development story points and 13 maintenance story points in sprint x). I don't even need a chart; a table will do great. But it needs to be broken down like in my example above. If rich filters could do that, I would be all set.

Thanks again, this is super helpful, much appreciated!

[Patty Land]

Sure thing! For question #2, Jira dashboard gadgets, including the plugin ones, don't really get to three dimensional filtering within a single view, however the Rich Filters plugin gives you a controller gadget, which allows you to quick filter your entire dashboard. So, you could have a two dimensional filter statistics gadget pulling in assignee by sprint, with total story points as your table values, and then you can quick filter the gadget by category to toggle through those. Or, you could pull in assignee by category and then filter by sprint, or have multiple gadgets for closed, open, and future sprints to show all data without quick filtering.

[Alina]

I can definitely work with this: "pulling in assignee by sprint, with total story points as your table values, and then you can quick filter the gadget by category to toggle through those."

This sounds like the best available solution. I will present both this and eazyBI to stakeholders and we'll move forward from there.

Thank you thank you!

[Marlene Kegel - codefortynine]

Hi @Alina,

I might be bit late to the party, but a third option could be Quick Filters for Jira Dashboards. :) 

If you want to check it out, you can have a look at our demo dashboards.

With our app you can filter you dashboard gadgets dynamically. 

You can also aggregate story points with the Quick Two Dimensional Filter Statistics gadget.

[Alina]

Thank you, Marlene! I do need a multi-dimensional filter; a two-dimensional one is not enough.