List Users For Specific Group From Custom Field (Multi User Picker)

Questions & Answers
,
1

Hi,

I have a custom field of type “multiuserpicker,” let’s call it “Partners.” Each user in Jira who is listed under “Partners” belongs to a specific group, such as Group A or Group B. I want to create a simple dashboard that displays a table of issues linked to “Partners,” with the “Partners” grouped in rows based on their respective groups. The columns should show the “Issues” measure.

From what I’ve read in articles, we can use the following formula:

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

its my formula:

[Partners].[Group A]  =
Aggregate(
  Filter(
    [Partners].CurrentHierarchyMember.Children,
    CoalesceEmpty([Partners].CurrentMember.get('Groups'), '') 
    MATCHES '.*(^|,)group_a($|,).*'
  )
)

However, when I try to use it with replace the dimensions with Partners, it doesn’t work. Is there something specific I need to do for custom fields, especially when dealing with the Multi User Picker type?

Here is the result of the query for the custom field:

{
    "id": 123456,
    "key": "JIRA-100",
    "fields": {
        "customfield_1100": [
            {
                "key": "JIRAUSER000011",
                "name": "abc",
                "displayName": "ABC",
                "emailAddress": "abc@gmail.com",
                "groupNames": [
                    "group_a"
                ]
            },
            {
                "key": "JIRAUSER000012",
                "name": "def",
                "displayName": "DEF",
                "emailAddress": "def@gmail.com",
                "groupNames": [
                    "group_a",
                    "group_b"
                ]
            }
        ]
    }
}

How can I display users in the table based only on a specific group that I choose, such as Group A or Group B? Is this possible?

I would appreciate any insights or guidance regarding this issue.
Thank You.

2

Hi,

There could be a partial solution to this use case, as eazyBI cannot import the group properties for the user picker fields. If we can rely on that all users from the Partners dimension is present in another standard user dimension (e.g., Assignee), we can use the following aggregation formula:

Aggregate(
  Filter(
    [Partners].[Partners].Members,
    StrToMember(
        "[Assignee].["||[Partners].CurrentMember.Name||"]"
      ).get('Groups') MATCHES '.*(^|,)group_a($|,).*'
  )
)

The idea is that the user picker field has the same user display names as the standard dimensions and we can look into the standard dimension to check the groups for the user.

The solution will not work if the user is not represented in a standard dimension.

Kindly,
Janis, eazyBI support