report for average time to complete by story point per team member

[George Apostolopoulos]

so I am able to pull the data into easy BI of all the points a team member completes, but how can I create an average of story point completion per team member? Thanks!

[Gerda Grantiņa · Accepted solution]

Hi @George Apostolopoulos 
​Do you want to see average story points per assignee based on the count of completed issues?
​Or average story points completed based on assignee count?
​Both are an option to calculate in eazyBI. 
​For the first the formula is:

CASE WHEN
[Measures].[Sprint issues completed]>0
THEN
CoalesceEmpty([Measures].[Sprint Story Points completed], 0)/
[Measures].[Sprint issues completed]
END

​​For the second the formula is:

[Measures].[Sprint Story Points completed]
/
Count(
Filter([Assignee].[User].Members,
[Measures].[Sprint Story Points completed]>0))

​
​And this is how both measures are displayed in the eazyBI report:

best,
Gerda // support@eazyBI.com
​

[George Apostolopoulos]

Perfect thank you so much!

[Twanna Gilliard]

hey Gerda what if i don't have access to eazy BI?