Hi,
We are trying to count number of bugs assigned and not assigned to particular company, using email ID of custom assignee field. We referred several examples of regular expression provided in EazyBI community discussions and documentation. But, there is mismatch in the count.
Bugs assigned to members of company email-ID
Aggregate({
Filter(
[Bug AssignedTo].[Bug AssignedTo].Members,
[Bug AssignedTo].CurrenthierarchyMember.Name MATCHES (".*@abc.def-ghi.xyz.com.*")
)
})
Bugs NOT assigned to members of company email-ID
Aggregate({
Filter(
[Bug AssignedTo].[Bug AssignedTo].Members,
NOT [Bug AssignedTo].CurrenthierarchyMember.Name MATCHES (".@abc.def-ghi.xyz.com.*")
)
})
Any recommendations to fine-tune this?
Thanks,
Vrukesh