nunka
June 11, 2021, 1:34pm
1
Hi,
I am learning how to use eazyBI. Can someone explain to me how I can calculate and display three sprint average predictability.
Using Sprint velocity report I displayed points committed and points delivered. Now would like to show predictability for each sprint and 3 sprint average predictability. How can I achieve this?
Many thanks in advance,
Hi @nunka ,
You would like to have a calculated measure to retrieve velocity in sprints. I used a calculated measure Story Points Velocity 5 Sprints from our demo account for this:
AVG(
Tail(
-- filter last 5 closed sprints for any Sprint selection
-- for an individual sprint it will show it's completed points
Order(Filter(
Generate(
{ [Sprint].CurrentHierarchyMemberā
ChildrenSet([Sprint].CurrentHierarchyMember) },
Descendants(
[Sprint].CurrentHierarchyMemb…
Hi @Yannick
Welcome to the community!
You may want to reuse “Running velocity for 5 closed sprints” measure:
instead of last 5 closed sprints, use last 3
filter sprints by the existence of Story points at closing, not by committed points
instead of “Sprint Story points completed” measure, use “Predictibilite” measure for the average calculation
The calculation formula would be the following (use correct measure “Predictibilite” with all specific characters):
CASE
WHEN
[Sprint].CurrentMem…
Best,support@eazyBI.com
1 Like