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

George Apostolopoulos February 16, 2022

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!

1 answer

1 accepted

0 votes
Answer accepted
Gerda Grantiņa
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 18, 2022

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:

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

​For the second the formula is:

[Measures].[Sprint Story Points completed]
[Measures].[Sprint Story Points completed]>0))

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


Gerda //

George Apostolopoulos February 24, 2022

Perfect thank you so much!

Like Gerda Grantiņa likes this
Twanna Gilliard
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 26, 2024

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


Suggest an answer

Log in or Sign up to answer