Sprint Velocity Report Stacked for Multiple Sprints

Questions & Answers
1

Hello

We are looking at creating a velocity report for a program level (which has multiple teams) where it will show points completed and committed across the program and not per team/sprint.

I can do a total view on a table however what I was looking at is showing a graph view similar to how a regular velocity report is shown except in our case we would want to combine all sprints into monthly reporting or quarterly.

2

Hi, @davor.fisher

Welcom back to the eazyBI community.

To create the program’s velocity report, I suggest summing up measures “Sprint Story Points committed” and “Sprint Story Points completed” for the closed sprints in the wanted period (monthly, quarterly).

The formula for “Story points Committed in period” would look something like this:

Sum(
  Filter(
    Descendants([Sprint].CurrentMember,[Sprint].[Sprint]),
    DateInPeriod([Measures].[Sprint end date],
        [Time].CurrentHierarchyMember)
     AND [Sprint].CurrentMember.get('Status')="Closed"
  ),
  ([Measures].[Sprint Story Points committed],
    [Time].CurrentHierarchy.DefaultMember)
)

Kindly,
Ilze