Calculate the number of unsprinted hours where in the backlog at the start of each sprint

Questions & Answers
1

I’m trying to calculate the number of hours (unsprinted) were in the backlog at the start of each sprint based on the selected board (sprint dimension). I’m assuming that I’d use Remaining Estimated Hours History and something to get the sprint start date. I’ve tried using this:

( [Measures].[Remaining estimated hours history],[Sprint].[Board].Hierarchy,
[Transition Field].[Sprint status],
[Sprint Status].[Active],
[Issue Sprint Status Change].[Future => Active],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
[Sprint].CurrentMember.get(‘Activated date’)
)
)

When I try, I just get same result as the hours committed. I’ve attached a screen shot of the report.

image
image726×472 24.2 KB

Can anyone help?

2

Hi @Shel_Price,

Yes, the given expression shows the hours that are committed to the sprint. eazyBI captures how many hours are still remaining when a sprint is started and considers that amount as a commitment because logged hours before a sprint are already done out of the sprint.

Please see the “Sprint Time Tracking (Remaining Estimate) balance” and “Time Tracking Burndown in Selected Sprint” report in the Demo account fr more options on how to analyze the Sprint effort:

Best,
Zane / support@eazyBI.com