Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos


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

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi Raghavendra,

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

Kind regards,

Martijn van Foeken | Interdobs