nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter issues by JIRA assignees in particular group (eazyBI)

Konstantin Balashow

Hi!
Could you help me to understand is my request is feasible.
I got group named "GROUP" with member inside (USER1, USER2, USER3) and want to find all tickets assigned to that group members. In JQL I easily can get by following query:
assignee in (membersOf("GROUP")). But I don't get how to do the same in MDX.

Accepted answers

Brittany Wispell

Hey @Konstantin Balashow

Filter(
[Reporter].[User].Members, 
CoalesceEmpty([Reporter].CurrentMember.get('Groups'), '') MATCHES '.*developers.*'
)

This is from an EazyBI doc you can find here: EazyBI documentation

Is this question related to EazyBI?

Thanks,
Brittany

All comments

Brittany Wispell

Hey @Konstantin Balashow

Filter(
[Reporter].[User].Members, 
CoalesceEmpty([Reporter].CurrentMember.get('Groups'), '') MATCHES '.*developers.*'
)

This is from an EazyBI doc you can find here: EazyBI documentation

Is this question related to EazyBI?

Thanks,
Brittany

Nic Brough -Adaptavist-

What type of Atlassian system is MDX?

Konstantin Balashow

Hi,
I tried this one, but receive following response:

Formula is not valid:
Member expression 'Filter([Reporter].[User].Members, (CoalesceEmpty([Reporter].CurrentMember.get("Groups"), "") MATCHES ".*GROUPNAME.*"))' must not be a set

Konstantin Balashow

It's query language in eazyBI, looks like I didn't specify product correctly

Brittany Wispell

Hey,

What version of EazyBI are you running?

I also found this in their documentation.

Member Functions

Calculated members in other dimensions

I'll keep looking for something that might already be put together.

Konstantin Balashow

Thanks for support!

I use version 6.2.2.

Zane eazyBI Support

Hi @Konstantin Balashow ,

There is no need to create custom calculations to get tickets assigned to some user group. You might want to use the dimension "Assignee Group" on report pages to filter data.

1) In eazyBI import options, tab Additional options, select to import user groups and import data: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-Additionaldimensionsforusergroups,intervals,andissuelinkfields

2) In the report, move "Assignee Group" on the report pages. Now you can filter report data by the user group in the Jira (see picture below).

eazyBI issues by assignee group.png

Best,
Zane / Support@eazyBI.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

eazybi