Average Velocity for Shared Resource over 5 closed sprints

Questions & Answers
,
1

I currently have a report built for each of my teams by users for Original Estimated vs hour logged per sprint (each team is on a different project). It will show the the average velocity per user across the last 5 closed sprints. Which is exactly what I want! My issue is, when I went to create the same report for shared resources who are across multiple teams it does not show me this info. I selected all the projects and sprints I wanted to review but it wont populate their velocity. How can I go about getting an average velocity for shared resources that work with multiple teams (multiple projects)?

The report that wont populate the shared resources

image
image1920×1010 53.7 KB

The report that is working for each team (User Est. vs logged hours and shows average velocity)

image
image1920×1010 86.3 KB

2

Hey @AnneDixon

Perhaps you can remove “Sprint” dimension from the cross project report and create an “average shared velocity” - calculated measure using the following formula that calculates the average from last x closed sprints (5 x count of projects) for the selected projects

   AVG(
    Head(
    Order(
    Filter(
      -- filter closed sprints
      [Sprint].[Sprint].Members,
       [Sprint].CurrentMember.GetBoolean("Closed") 
       AND
    (
    [Time].Currenthierarchy.DefaultMember,
    [Assignee].CurrentHierarchy.DefaultMember,
    [Issue].CurrentHierarchy.DefaultMember,
    [Measures].[Issues resolved]
    )> 0
      ),
      [Measures].[Sprint actual end date],
      BDESC
      ),
      -- set the count of last closed sprints for running velocity
      5 
      *
      --count of selected projects
      CASE WHEN
      [Project].CurrentHierarchyMember.level.name = "Project"
      THEN
      1
      WHEN
      [Project].CurrentMember.level.name = "(All)"
      OR 
       [Project].CurrentHierarchyMember.level.name = "Category"
      THEN
      Count(ChildrenSet([Project].CurrentHierarchyMember))
      WHEN
      --if no project selected
      [Project].CurrentHierarchyMember is 
      [Project].CurrentHierarchy.DefaultMember
      THEN
      1
      END
      ) ,
      [Measures].[Hours spent]
  )

Martins / eazyBI