Calculate Team Predictability

[Joni Johnson]

I am wanting to calculate the percentage of committed points per sprint divided by the actual points completed per sprint for every team using JIRA. I want to graph for each team the percentage in reference to 100% as the target with a + or - range to see how well the team hits within the control limits for the past six sprints.

The velocity report has the data for individual teams. 

Has anyone automated this? If so, how? Is there a way to hit the database directly to select the information? Is there a good way to get this data without writing an application to use the API's?

[Jakub Sławiński]

@Joni Johnson 

if you are using Jira Cloud, then using API's seems to be the only option.

How many teams do you have? How frequent?

If you have only few teams, you can display several velocity gadgets on your dashboard to visualize all the teams in one place.

[Joni Johnson]

We are using JIRA server version (on premises).

We have 11 teams that are on a two week sprint schedules. The teams are one different cycles.

Thank you for the suggestion.