[EazyBI] Arbitrary grouping dimension members

Hi All,

Simple question that puzzles me: I want to arbitrary group several dimension members (for example ticket reporters). I do it frequently with MS Excel, but I have absolutely no clues on how to do it with EazyBI and I failed finding it in the documentation.

Thank you for your help!

1 answer

1 accepted

Hi Jerome!

To group several dimension members you can use the Aggregate(set) MDX function in eazyBI dimension calculated members where you wish to group some members.

For example, if I would like to aggregate two reporters with JIRA user display names John and Anne, then the formula in Reporter dimension would be as follows

Aggregate({
  [Reporter].[Anne],
  [Reporter].[John]
})

Or you can also use the Filter for all dimension members and only find the ones that match some condition. See examples about reports using JIRA user groups.

Let me know if you have additional questions!
Lauma

Hi Lauma, Once again perfect answer :). Thanks for you quick and efficient help! Jerome

A follow up question on this. How can I find out how many members belong to the above group created.

Hi Dipti, To count how many users are in the Aggregated set you can use the Count function (https://docs.eazybi.com/display/EAZYBI/Count). For example the following would count how many users are in Assignee calculated member named 'Developer group' Count( ChildrenSet([Assignee].[Developer group]) ) Kind regards, Lauma / support@eazybi.com

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,024 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot