Count with conditional on text fields

[fernandorech]

Hello everyone,

I want to count hashtags on text fields, we have 3 hashtags based on the complexity of the task: 'low', 'medium', 'high'

Ex: "We need to finish the contract #medium"

I've tried approaches like  count({<text_field={"*#low*"}>} id)

or using wildmatch but none of them works.

Could someone help me.

Thanks

[jheasley]

try using single quotes to create a string in the set analysis statement:

count({<text_field={'*#low*}>} id)

[fernandorech]

Hi,

Yes, I'm using single quotes on the statement,  I wrote wrong on my question, sorry.

There's another error ?

Thanks

[Rodrigo_Reis]

If you need to count how many records has a specific hashtag, then you will use "count". In this case your current expression is correct.
If you need to count the number of hashtags in a record, then you can use "substringcount".

Can you upload a file as an example?