Search to Insight Functionality - Need to search a text column on a key word

[raghavendra_p]

Hello,

In my model, I have a comments column , which contains free text like ex -"This required new changes" or "This is enhancement" ..etc. Now I would like to use this column in "search to insight" to find trend.

Ex, I need to find total count of rows having a key word "new changes" or "enhancements".

please advise how to do this? In Search to Insight search bar, can we use 'contains' for searching string/text? or search symbols like * ? % ..etc.

or Is there any other way to achieve this?

Thank you for your help

[mfoeken]

Hi Raghavendra,

I would try to create a calculated dimension using the formula editor and use the LIKE ( , ) function.

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.17/en-US/3b7c99a7a7cd4a29bb1c5132d91a...

Kind regards,

Martijn van Foeken | Interdobs