Filter issues by JIRA assignees in 2 groups (eazyBI)

Seifallah_Bellassoue · October 25, 2022, 3:45pm

Hello,

I want to filter assignee by all Members who are in 2 groups on the same time. for example on Developers group and Approvers groups.

I found on the doc this filter.

Filter(
[Reporter].[User].Members, 
CoalesceEmpty([Reporter].CurrentMember.get('Groups'), '') MATCHES '.*developers.*'
)

I can filter by only developers group but not Approvers group.
Any help pleaze ?
Thanks in advance.
Regards,
Seif,

gerda.grantina · October 28, 2022, 2:29pm

Hi @Seifallah_Bellassoue ,
You can filter the groups by applying two conditions in the same formula. You can create a calculated member in the “Assignee” dimension using this formula:

Aggregate(
  Filter(
    [Assignee].[User].Members, 
    CoalesceEmpty([Assignee].CurrentMember.get('Groups'), '') MATCHES '.*jira-users.*'
    AND
    CoalesceEmpty([Assignee].CurrentMember.get('Groups'), '') MATCHES '.*jira-servicedesk-users.*'
  )
)

And then, in the report, it would look like this:

best,
Gerda