How to tracking the Sprint Ready Backlog across Time

Questions & Answers
2

Hi @Jon

You would need a custom calculation that iterates through imported issues for each sprint.

Try something like this to count completed story points for the issues in ready status at the end of time period and with date in ready between your two required dates.

NonZero(
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Datebetween(
	[Measures].[Issue date in ready],
	'2021-06-01',
	'2021-06-01')
AND
([Measures].[Issues history],
[Issue Type].[Story],
[Transition Status].[Ready])>0
),
[Measures].[Sprint story points completed]
)
)

Then you would use the new measure for the Velocity calculation instead of Sprint Story Points completed.

There I am suggesting a formula Descenants is heavy because it iterates through all imported members in the “Issue” dimension, therefore it can be much slower than using regular tuples.
Please enable the “Nonempty” cross join in the report for these calculated measures.

See similar questions here:

Martins / eazyBI support