How to calculate 3 sprint average sprint predictability

[gerda.grantina]

Hi @nunka ,
You can see some suggestions about the solution for sprint average predictability here in similar Community topics:

9. Prediction reports

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…

Determine for Each Sprint the Average Predictability for the last 4 Sprint

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,
Gerda // support@eazyBI.com