How to show how much story points Developer resolved by the sprint?

Questions & Answers
, , , ,
1

Hi,

I need a help with creating a Diagram, which will show me how much story points resolved developer in the last closed sprint and the median of story point which he/she resolved in the past 5 sprints?
One more thing I want to mention that it would be greate if this report could be Sorted by group of developer.
I have tried to change diagram from the EasyBI documentation ( Story points balance by sprints - Issues - Jira Demo - eazyBI , Sprint velocity chart) , but it doesn’t help me.

Thanks in advance for your assitance!

2

@eazyBI-Staff I would be greatfull if you would be able to help me with it!)
THank you in advance!

3

Hi,
The following formula counts the completed story points per user for the last closed sprint:

([Measures].[Sprint Story Points completed],
Tail(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentHierarchyMember.Get('Status')="Closed"
    AND
    ([Measures].[Issues created],
     [Assignee].DefaultMember)>0
  )
).item(0)
)

This formula expects the Assignee dimension in the report and considers the last closed sprint if any of the developers have completed any issues in the sprint.

The following formula finds the median of story points completed per user from the last five closed sprints:

Median(
Tail(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentHierarchyMember.Get('Status')="Closed"
    AND
    ([Measures].[Issues created],
     [Assignee].DefaultMember)>0
  ), 
  5
),
([Measures].[Sprint Story Points completed])
)

Kindly,
Janis, eazyBI support