Calculating average velocity for last ' X ' no of sprints

[Pooja Wandile]

HI,

I would like to know if there is any API or JQL functional that can generate average velocity for last/previous 'x' sprints, for e.g. let's say I want average velocity to be calculated for last 4 sprints. I am not looking for any paid plugin in marketplace. 

Thanks,

Pooja

[Dan -minware-]

Disclaimer: marketplace partner!

Hey @Pooja Wandile -

I see Bill mentioned what you are looking for is not possible natively so I wanted to let you know about minware. 

We calculate velocity at the per-ticket level and we are currently working on rolling this calculation up to epics. Here's an example of ticket velocity:

You can see the estimate ("1" in gray) and the actual time the task took ("2.7" in blue). We then divide the story point estimate by the actual time the task took to come up with a velocity calculation ("0.36" in red).

Here's an example view that I have filtered to show the sprints going into one epic:

The tickets sit inside these sprints and we should have aggregate epic metrics available soon. Please let me know if this would be helpful!

[Bill Sheboy]

Hi @Pooja Wandile 

Short answer: no that is not possible with out-of-the-box Jira features.

Longer answer:

JQL is a tool to query issues, is not a SQL, and cannot aggregate the results of queries.  There are built-in reports in Jira to show information about sprints but they also do not show aggregate information like this for non-issue information (e.g. sprints).

As you note a desire to not use marketplace options, some work-arounds you could try are:

• review the results of each sprint report (or the velocity report), record the values and calculate the average
• select your issues of note with JQL, export the results to a spreadsheet, and create a report by summarizing/pivoting on the sprint field
• build an application which calls the REST API, and similar to above summarizes the results

Kind regards,
Bill