In EazyBI how can I filter time logged by users that are within a named JIRA user Group?

[graemejohnson]

Hi

My team of developers is split four separate sub-teams, and as such, within JIRA I have added them into into one of four groups...

• Green_Team
• Red_Team
• Blue_Team
• Yellow_Team

Looking through some of the Eazybi documentation, it appears you can filter on time logged by user group.  I have borrowed this and adapted for my needs....

Aggregate(
 Filter([Logged By].[User].Members,
 CoalesceEmpty([Logged By].CurrentMember.get('Groups'), '') 
 MATCHES '.*(^|,)Blue_Team($|,).*'
 )
)

However, it results in no data being returned.

What I have noticed however, is that when I report on  'Assignee Group's for a given JIRA user, it shows Group names that reflect mail server mailing groups NOT JIRA group names - hence the reason why my filter returned no matches.

So after all of that....how do I filter on time logged by people within a certain JIRA group?

[graemejohnson · Accepted solution]

I found the answer.......I refreshed my cube!

[Sir Mārtiņš Vanags]

Hi Graeme,

We are happy you found an answer by yourself.

Please note that there is a possibility to import JIRA user groups as dimensions via import settings.

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com