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,