Filter issues by JIRA assignees in 2 groups (eazyBI)

Seifallah Bellassoued

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.

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

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

Martins Vanags_eazyBI

Hi @Seifallah Bellassoued 

Why woud you use the "Reporter" dimension if you need to filter assignees?

The way I understand your question you need to create a calculated member in the "Assignee" dimension using the following formula:

 

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

 

Martins / eazyBI