Rolling avg velocity for last 5 sprints

Questions & Answers
1

I am trying to create a velocity chart showing multiple teams within the same project and only want to see the last 5 closed sprints. what will the query be? I have tried different options found on multiple websites and can find one that works can someone please help out?
Our project has about 5 boards. I want a rolling avg velocity for the last 5 sprints per board. I want to do a calculated member on the sprint dimension to only show the last 5 closed sprints.

2

Irese,
Please, find here a formula calculating the rolling average velocity for the last 5 closed sprint in the board. The calculation is designed to work with the Sprint dimension, Board level:

Avg(
  Head(Order(
    Filter(
      [Sprint].CurrentHierarchyMember.Children,
      [Measures].[Sprint closed?]="Yes" AND
      NOT IsEmpty([Sprint].CurrentMember.get('Complete date'))
    ),
    [Measures].[Sprint start date],
    DESC
  ),5),
  [Measures].[Sprint Story Points completed]
)

I attached a small example report to show how the measure work:

Board%20velocity
Board velocity.png1786×1560 248 KB

Kindly,
Janis, eazyBI support

2 Likes