Count distinct Assignees in a period of time per component

Questions & Answers
1

Hi,
is there a way to count distinct assignees in period of time for open issues per component?
issue-1 | John Doe | componentA
issue-2 | Jane Doe | componentB
issue-3 | John Doe | componentA
issue-4 | Jane Doe | componentC
issue-5 | Jane Doe | componentB
issue-6 | Jonny Be | componentA

Result-Table:

||Component||Assignee Count||
|componentA| 2|
|componentB| 1|
|componentC| 1|

Thanks and kr
Jo

2

Hi @Jo_Kr

Yes, you may want to create a Maesure, that iterates through all Assignee dimension User level members and count those having open issues at the end of the selected time period:

Count( 
 Filter(
  [Assignee].[User].Members,
  [Measures].[Open issues]>0
  ))

Best,
Ilze / support@eazybi.com