nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

George Apostolopoulos_06gcc7

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!

Accepted answers

Gerda Grantiņa _ eazyBI

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

All comments

Gerda Grantiņa _ eazyBI

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_06gcc7

Perfect thank you so much!

Twanna Gilliard

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

report