Hello,
I am trying to create a daily report that gives me the number of sprints worth of work we have that is pointed and in the ready status. Ideally, it would be Sum(Total committed points in ready status in a future sprint or backlog)/5 sprint running velocity.
Here is how far I got…
I created a calculated member in transition status to filter on ‘ready’ `
Aggregate({
Filter([Transition Status].Members,
[Transition Status].[Status].CurrentMember.Name matches ‘Ready’)
})
I also created a calculated member that only pulls in the stories in the backlog or future sprints
Aggregate(
Filter([Sprint].[Sprint].Members,
[Sprint].CurrentMember.Name = “(no sprint)” AND
NOT [Sprint].CurrentMember.GetBoolean(“Closed”) or
–sprint start date is in future or not set yet
(IsEmpty([Sprint].CurrentMember.get(‘Start date’)) OR
DateCompare([Sprint].CurrentMember.get(‘Start date’),
“today”) > 0)
)
)
I haven’t been able to get the running velocity to populate so I can divide it with the story points remaining number my report is deriving. Any help would be greatly appreciated!