EazyBI - Calculated measure for user picker (multiple users)

Miroslav Kralik March 14, 2018

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 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events