Hi all! I am looking to create a measure that shows the percentage of the issues in a Sprint that were created within x days of the Sprint start date. Any ideas would be greatly appreciated.
Some background - When stories are created within a week before the Sprint start date for the Sprint they are worked on I have noticed they have a higher likelihood of rolling over. It makes sense given these stories have less time ahead of the sprint to benefit from backlog refinement activities, estimation discussions, etc.
I ultimately want to show the relationship of these last minute stories to rollover in the Sprint.
You can use this formula to get the percentage of issues that have been created X days before the sprint start date (change 5 to any other day count you wish to see):
CASE WHEN
[Measures].[Sprint issues committed] > 0
THEN
Sum(
Filter(
DescendantsSet(
[Issue].CurrentHierarchyMember, [Issue].CurrentHierarchy.Levels("Issue")),
[Measures].[Sprint issues committed] > 0
AND
DateDiffdays(
[Issue].CurrentHierarchyMember.Get('Created at'),
[Sprint].CurrentHierarchyMember.Get('Start date')
) < 5
),
[Measures].[Sprint issues committed]
)
/ [Measures].[Sprint issues committed]
END
