Devide Story Point due through velocity

Questions & Answers
1

Hello,
i’m struggeling with the simple task to devide “Story Points due” within the Project Dimension through the “avarage running velocity for 5 closed sprints”.

What i have done so far:
I created a new calculated Measure to get the Running Velocity per Board:
Avg(
Head(Order(
Filter(
[Sprint].CurrentHierarchyMember.Children,
[Measures].[Sprint closed?]=“Yes” AND
NOT IsEmpty([Sprint].CurrentMember.get(‘Complete date’)) AND
[Measures].[Sprint Story Points completed] > 0
),
[Measures].[Sprint start date],
DESC
),5),
[Measures].[Sprint Story Points completed]
)

Then i realized, that Story Points due are most likely in our Backlog and so not assigned on any board (Board is a hierarchy member of Sprints, so unresolved Storys are assigned to (no board)).
So what we would need is basicly what i said.
Project on Rows and [Measures].[Story Points due] / Velocity of the last 5 Sprints within this Project (Or any Board within the Project)

Background:
We want to know how many Sprints could be filled with the Story Points in our Backlog.

Does anybody has some help?
Thank you in advance,

2

In eazyBI demo account, there is an example report similar to your needs:
https://eazybi.com/accounts/1000/cubes/Issues/reports/166439-story-points-progress-and-velocity-by-sprints-in-epic

There is Epic Link dimension in the report. You can switch it to any other dimension, for example, Project to see current progress by project, velocity of the last 5 sprints and how many predicted sprints there are based on Story Points due and this velocity. This report uses a bit different version of velocity calculation by sprints.

Daina / support@eazybi.com

1 Like