How to build a report that shows story points per sprint per assignee (at any point of the sprint)

[Jack_Pio]

I am trying to build a report that shows story points completed per sprint per assignee. However I would like it to count as an assignee if that person was assigned to the issue at any point and the issue was closed in the sprint.

Thanks!

[ilze.krauze]

Hi Jack_Pio,
Welcome to the eazyBI community!

You can create new calculated measure using following formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    -- filter issues that where ever assigned to assignee
    ([Measures].[Transitions to assignee],
    [Sprint].CurrentHierarchy.DefaultMember)>0
    ),
    -- sum story points completed in selected sprint
    ([Measures].[Sprint Story Points completed],
    [Assignee].CurrentHierarchy.DefaultMember)
  )

If issue has been assigned to several people, then this formula will show its story points for all these assignees.
For example, issue DA-274 where last assignee is Daina, but it has been assigned to Sandra and Duncan previously. New calculation in last column shows those story points for each assignee:

Let me know if that works for you, or if you had something different in mind.

Best,
Ilze

[Jack_Pio]

Hey Ilze, thanks so much for the reply!

Yep that seems to work but it’s very slow on load and timeout when I add in new assignees. Do I need to pull in less data for this measure to work properly?

Thanks!