[EazyBi] How to group users by their email

[Aurelie Pilette]

Hello,

Our JIRA is used by our company and by our customers.

We have a jira group for people who works in our company "Company-users"

We can identify them by their email which contains "company.com"

So, how can I filer my chart on easybi to have only People of my company.

I try the following step but it doesn't work :

Aggregate(
Filter([Assignee].[User].Members,
CoalesceEmpty([Assignee].CurrentMember.get('Groups'), '')
MATCHES '.*(^|,)(Company-users($|,).*'
)
)