How to create and automated why to gather team size in a sprint from JIRA

[Michael Soby]

This may be a tough one.  I was provided a new project to add to our Sprint Completion metrics.  Currently over 10 teams I enter the velocity of each team into a spreadsheet so we can see from sprint to sprint and quarter to quarter how we are doing making our sprint completion metrics.  This is done by hand.  Now I need to add the size of each team per sprint.  This information in theory is in Jira if using sprints and sprint boards.  How can I pull this information out automatically after each sprint is completed?  

• Team size over each sprint (especially moving forward in Q3)
• Looking to be able to determine how much work teams can take on
• Understand different flows and fluctuations in work that is being done based on this information
• In the future understand the size and complexity of the stories 
• Any way to do this automatically???

[Brad Quirk - Quirk Consulting]

Hi Michael,

I don't believe there is any current functionality within Jira to make this specific question an easy one.

However, what I've done in the past to tackle this problem is to dig into the Jira API and extract the issue history for each sprint ticket. this contains when people were added (or removed) from each ticket. Depending on what logic you want to add in there (e.g. if someone was removed from the ticket, does it count anymore?) you can simply add the total number of assignees at the end of the sprint to have your team size.

Hope that helps!

Brad