How to use the regular expression in aggregation rule?

Solved491 viewsaggregation Regex
2
0 Comments

I’m trying to count the rows that contain a string for a certain column. However, I can’t figure out what value to specify for the regular expression.

Below is an example of what I want to achieve. Trying Thread problem without the quotes doesn’t solve the issue.

Currently, the rule is counting all rows and doesn’t take the condition into account.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th May 2024

1 Answer

0
7.00K 0 Comments

I’ve tried this a couple of times last year as well and noticed the same thing. I assume it’s broken for row counts as it seems to work for other things. I worked around it for instance by taking the percentage of rows rather than the count, which also worked for my use case.

The Regex for your “contains” by the way is .*Thread Problem.*

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th May 2024