Counting issues with a specific phrase in the summary

Questions & Answers
,
1

Hey team,

I am trying to develop a report that counts only issues (of any type) that has the term ‘PB Action’ in the summary.

I am struggling to work out how to write a calculated measure to do that, or even if it can be done?

I have tried the following:
Aggregate(
Filter(
[Issue].[Issue].members,
[Issue].CurrentMember.name MATCHES ‘PB Action *’
)
)
But no luck bringing up the issues I am wanting to show in a report.

Thanks in advance for your assistance/advice.

Cheers

Dave

2

Hi @David_Horne,
​
​If you only need to count the issues containing the specific phrase in the summary, you might use the Count() function.
​
​However, if you need to identify those issues and perform additional calculations besides finding the total number, you would do better by categorizing the issues for allegiance to a specific category.
​
That topic was raised and presented in eazyBI community days last year - please see the presentation by my colleague Nauris here - eazyBI Community Day 2023: Recordings and Presentations.
That presentation might give you some inspiration on how to categorize issues.​
​
Using the JsvaScript calculated ​customfield dimension greatly improves the reporting performance compared to iteration through all the issues in the data cube.
​
Regards,
​Oskars / support@eazyBI.com

1 Like
3

Thanks @oskars.laganovskis , I’ll have a look today.

Cheers

Dave

4

Hi David, Hi Oskars. I have the same problem and checked a videos, but still open topic. I’ve using next structure for grep “TEXT_FIND_FROM_SUMMARY” from summary:

Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Measures].[Issue].CurrentMember.GetProperty("Summary") MATCHES ".*TEXT_FIND_FROM_SUMMARY.*"
  )
)

still unexpect result. maybe you find great solution? could you share if yes. Thx

5

Hi @Oleksandr_Korol ,

Please share more details about your requirements and the actual setup on your instance to support directly over e-mail to assist you better.

Regards,
Oskars / support@eazyBI.com