Can't see Groups Property for custom User picker field

Questions & Answers
1

Hi,

I have a custom user picker field called Reviewer, and I want to use it as in calculated member to check if a user in a group. I’ve successfully used the Assignee field, and the following code from documentation works:

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

However, when I replace Assignee with Reviewer, I encounter an error: “Formula is not valid: More than one function matches signature ‘.Members’; they are: .Members, .Members.”

Aggregate(
  Filter([Reviewer].[User].Members,
    CoalesceEmpty([Reviewer].CurrentMember.get('Groups'), '') 
    MATCHES '.*(^|,)JIRA_Test Group($|,).*'
  )
)

I’ve attempted to check if the Group property exists using the following measure:

[Reviewer].CurrentMember.AllProperties

However, it only returns Key. Contrastingly, when I use the same measure for Assignee, I can see Group among the properties.

Can anyone help me understand how to retrieve the Group property for a user from the custom user picker field Reviewer?

2

@AlenaS

Importing groups and a few other properties to members in user picker fields is an eazyBI feature designed for standard Jira user-picker fields (Reporter, Assignee) but not for every Jira user-picker custom field.

We have an improvement request on our backlog to automatically import all user-related properties for all custom user-picker fields (imported in eazyBI), but I can’t promise the release date.
We will let you know when this is possible in eazyBI.

A workaround is combining users from the “Reviewer” dimension into calcualted members using aggregates.
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions
In some use cases (if the Reviewer is also found in the Reporter or Assignee dimension), there can be user-defined calculated measures that return the missing properties from the Reporter dimension (by finding the same user).

Martins / eazyBI team