Create an assignee calculated member with the assignees not included in any other assignee calculated member

Questions & Answers
,
1

Hi all

I have created some calculated members with assignees based on the teams we have, but there are some tickets assigned to people not belonging to any team in particular.

How can I group those people in an “others” assignees calculated member without adding them manually?

Thanks

W.

2

Hello? Anyone can help??

3

Hi @walterdp,

Thanks for posting your question.

You can use the following formula to group members that are in neither of the Assignee groups. This formula assumes that you have some users assigned to Group 1 and Group 2.

Aggregate(
  Except(
    [Assignee].[User].Members,
    {ChildrenSet([Assignee].[Group 1]),
     ChildrenSet([Assignee].[Group 2])}
  )
)

In a very simple report, it would look something like this:

image.png
image.png1542×1018 80.3 KB

I hope this helps.

Best,
Marita // support@eazybi.com

1 Like