eazyBi - Counting Unique Assignees per Sprint

[Mircea Marin]

Hi,

We have a report that shows a couple of statistics for the past 5 Sprints. The Rows are composed of the Sprints. I would like to know if it’s possible to find the number of people that have been assignees for the tasks (stories, subtasks, etc.) in each sprint. For example:

• Task 1 – Max
• Task 2 – Christine
• Task 3 – Adrian
• Task 4 – Christine
• Task 5 – Adrian
• Task 6 – Ana

Team Members = 4

Thanks,

Mircea

[Janis Plume _eazyBI_ · Accepted solution]

Mircea,

Several similar solutions for this calculation would be appropriate. For instance, the following formula calculates the number of assignees working on any committed or added issue to the sprint:

NonZero(Count(
  Filter(Descendants([Assignee].CurrentMember,[Assignee].[User]),
  ([Measures].[Sprint issues committed]+
  [Measures].[Sprint issues added])>0)
))

You can adjust the measures used in the condition of the Filter function to cover some other cases when counting the assignees for the sprint.

Kindly,

Janis, eazyBI 

[Mircea Marin]

Hi Janis,

thanks for the answer. Based on your suggestion I came up wit a solution that is a bit different, adapted to our use case:

Created a new Measure called "Stories and Subtasks resolved":

 ([Measures].[Issues resolved],
 [Issue Type].[Story]) + 
 ([Measures].[Issues resolved],
 [Issue Type].[Sub-task])

Then created the actual needed measure:

NonZero(Count(
 Filter(Descendants([Assignee].CurrentMember,[Assignee].[User]),
 ([Measures].[Stories and Subtasks resolved]) >0)
 ))