Create a new calculated member which searches for Jira-issue summaries

Questions & Answers
1

Hi there,

In our Project are round about 100 Components which have the same standard-issues for every component, so the summaries of these issues are identical.

Now is my question: Is it possible to create a calculated member in eazybi to filter these summaries OR is there a way to integrate a JQL-filter from Jira into eazybi with this I can filter them?

Aggregate(
Filter(
[Issue].[Issue].Members,
[Issue].CurrentHierarchyMember.Name MATCHES ““Summary””
)
)

Is it possible with something like that?

Thank you and sorry for the bad description! I work with eazyBI the first time and it have to be ready at the end of this week.

Regards Michi

2

Hi @Michi10,

The calculated member should work if created in the Issues dimension. Please take into account that the Issue dimension current hierarchy members name also contains the issue key. I would recommend using regular expressions, overcome this:

Aggregate(
    Filter(
        [Issue].[Issue].Members,
        [Issue].CurrentHierarchyMember.Name MATCHES '.*summary'
    )
)

The ‘.*’ indicates that there could be zero or more symbols in front of the summary. You can read more about this on the eazyBI documentation page - https://docs.eazybi.com/eazybijira/analyze-and-visualize/regular-expressions.

Kind regards,
Robert // eazyBI staff

1 Like