Aggregate several items by name into new list

Questions & Answers
1

Hi team,
I have calculated formula

Aggregate({
[Root Cause].[Test bed HW issue - other],
[Root Cause].[Test bed HW issue - jumper wires],
[Root Cause].[Test bed HW issue - relay],
[Root Cause].[Test bed HW issue - debug board],
[Root Cause].[Test bed HW issue - USB cable],
[Root Cause].[Test bed HW issue - RPI],
[Root Cause].[Test bed HW issue - dummy / shelfish],
[Root Cause].[Test bed HW issue - PoE],
[Root Cause].[Test bed HW issue - FTDI],
[Root Cause].[Test bed components issue - other],
[Root Cause].[Test bed components issue - RPI],
[Root Cause].[Test bed components issue - USB cable],
[Root Cause].[Test bed components issue - debug board],
[Root Cause].[Test bed components issue - relay],
[Root Cause].[Test bed components issue - dummy / shelfish],
[Root Cause].[Test bed components issue - FTDI],
[Root Cause].[Test bed components issue - jumper wires],
[Root Cause].[Test bed components issue - PoE]
}
)

Is there a way to replace direct naming the items with some regex / universal solution like: [Test bed components issue - *]

?

2

Hi Lev,
Welcome to the eazyBI community!

You can filter dimension members that match the pattern by using Aggregate with Filter function:

Aggregate(
  Filter(
    [Root Cause].[Root Cause].Members,
    [Root Cause].CurrentMember.Name MATCHES "Test bed components issue.*"
  )
)

.* is used to represent any number of any characters, more about available regular expressions here: Regular expressions

Best,
Ilze

3

Thank a lot! It worked for me.
Also related question to this topic, I have a list in Jira with many items and now I choose every item one by one.
Is there any way to show all “Root cause” items instead of clicking them one by one as I do now?

image
image348×876 41 KB