Counting number of assignee under an epic

Questions & Answers
1

Hi eazyBI Community,

I’m trying to count the number of assignees, but I want to exclude the “Unassigned”.

Count(
Filter(
[Assignee].[User].Members NOT (“Unassigned”),
[Measures].[Issues created] > 0
)
)

But it doesn’t work and gives me the following error message:

Child process request failed with Errno::ECONNREFUSED:
The child process will be restarted now, please retry the request in a minute.

I don’t like to see that 3 people are assigned to the parent issue, when there are actually only 2

image
image1323×196 18.5 KB

2

Hi @HRivest,

You can use the following formula that counts the number of assignees except for the “unassigned”:

Nonzero(Count(
  Filter(Descendants([Assignee].CurrentMember,[Assignee].[User]),
    [Assignee].CurrentHierarchyMember.Name<>'(unassigned)'
    AND
    [Measures].[Issues created]>0
  )
))

Best,
Marita // support@eazybi.com