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.

[Brittany Wispell · Accepted solution]

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

[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

[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.

[Brittany Wispell]

Might this be similar to what you're looking for? 

Reports using Jira users 

Sorry, I don't have my own test environment for this or I would test it out myself. 

Hope we are getting closer to a solution for you. 

-Brittany 

[Konstantin Balashow]

Thanks, trying this but result is empty, currently I'm waiting for answer from my Tooling team, because it may happen due to we have Active Directory groups instead of JIRA user groups.

[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).



Best,
Zane / Support@eazyBI.com

[Nic Brough -Adaptavist-]

What type of Atlassian system is MDX?

[Konstantin Balashow]

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