Filter Custom Field by Assignees

[larryrtn]

Hello,

I am using a custom dimension called “Code Reviewers” that pulls from Jira Users just like the built-in “Assignee” dimension and would like to filter down the “Code Reviewers” to only Developers.

For assignees I can easily do this using “Assignee Groups” in a calculated member that I call [Assignee].[Developers].

For example, if I have the following:

Assignee	Group
Dave	Developer
Katie	Developer
Julie	QA
Bob	QA

[Assignee].[Developers] yields: Bob (developer), Julie (developer)

But I do not have a “Code Reviewers Groups” to use in this case. I was thinking of using the [Assignee].[Developers] to filter down “Code Reviewers” into [Code Reviewers].[Developers], but cannot figure out how to do this.

How can I create [Code Reviewers].[Developers] that gives me the same type of results as [Assignee].[Developers]?

Thank You!
Larry

[gerda.grantina]

Hello @larryrtn
Yes, your observation is correct—groups are imported as properties and dimensions only for a few specific Jira fields (Reporter, Assignee, and Logged by), and this information is not available for other user dimensions.
As a workaround, you can get the groups for your user picker field using the assignee dimension property “Groups”:

[Assignee].[Assignee].Members.Item(
  [User Picker].CurrentHierarchyMember.Name
).GetString('Groups')

This approach only works if all your “Code Reviewers” are also present in the “Assignee” dimension.
In the report, you can apply row filtering to get users that are members to a particular group: https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Orderandfilterrowsbymeasurevalues

Best,
Gerda // support@eazybi.com