Velocity over the last five sprints for stories added mid sprint

Questions & Answers
1

I’m working on a report that identifies stories added mid-sprint, along with the hours spent on those stories. Additionally, I want to calculate the velocity for the past five sprints based on the hours spent on stories added mid-sprint. While I can successfully pull the stories added mid-sprint, I’m having trouble creating a measure that calculates the velocity over the last five sprints specifically for those stories (hours spent).

I am trying to get the velocity of each users unplanned work. Can someone please assist?

Thank you!

2

Hi @AnneDixon

Thanks for posting this question!

To find the logged hours only on issues that were added to the sprint after it got started, please try the measure below. This will display logged hours on issues that were added to Sprint after it got started and the Hours were logged during the Sprint.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Sprint issues added] >0
  ),
  [Measures].[Hours spent]
)

If you want to capture the Hours logged on issues added after the sprint, regardless of when the Hours were logged (outside the selected sprint), please use the measure below:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Sprint issues added] >0
  ),
  ([Measures].[Hours spent],
  [Sprint].CurrentHierarchy.DefaultMember)
)

Here’s the Velocity of Hours spent on issues added after the sprint started

CASE WHEN
  [Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND
  [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
THEN
  Avg(
    Tail(
      Filter(
        [Sprint].CurrentHierarchyMember.FirstSibling:[Sprint].CurrentHierarchyMember,
        [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
      ),
      5
    ),
    Sum(
      Filter(
        Descendants([Issue].CurrentMember,[Issue].[Issue]),
        [Measures].[Sprint issues added] > 0
      ),
      [Measures].[Hours spent]
    )
  )
END

Best wishes,

Elita from support@eazybi.com