Hello,
I need to create a new calculated measure to get number of resolved issues which contain specific user(s) in custom field of type user picker (multiple users). In my case the custom field name is "Resolver(s)".
I have the query below, but it does not work as expected -> 0 results.
Aggregate(
Filter([Resolver(s)].Members,
CoalesceEmpty([Resolver(s)].[User].CurrentMember.get('key'), '')
MATCHES '.*(^|,)(username1|username2)($|,).*'
)
)
Any idea how should the query look like?
Thank you, Miroslav
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.