Filter dataset for issues that have certain wording in title

Questions & Answers
1

Is it possible to create a set of issues that have a certain word in the title? For example the word “TEST”.

Thanks.

2

Hi,

Yes, it is possible to create an aggregated member in the Issue dimension by pattern matching in the Issue summary:

Aggregate(
  Filter([Issue].[Issue].Members,
  [Issue].CurrentMember.Name MATCHES ".*TEST.*"
  )
)

I would, however, recommend avoiding such constructions in eazyBI. This formula iterates over a full set of Issues and is very likely to have performance problems when used in reports.

Your use case indicates that there is a business logic implemented with the naming convention of Jira Issues. You may consider using the proper Issue type or a custom field for identifying a specific kind of issues. That would make the filtering much more efficient in eazyBI.

Alternatively, you may consider implementing the Javascript calculated custom field in eazyBI and precalculate the Issue name patterns during the data import. See here for more in the eazyBI documentation:
https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields

This topic was also discussed in the presentation from the latest eazyBI community days:

Kindly,

3

Thanks a lot Janis; that´s great valuable information!

4

Hi @janis.plume ,
I can able to get the counts by using this script but not able to drill through and it just whole created issues instead.

5

Hi,

Please contact support for further guidance. We need to see the definition of the report where you used this formula.

Kindly,
Janis, eazyBI support