This content has been marked as final. Show 2 replies
I have following columns. 'TravelSummary', 'Month'
Travel summary is a text field. The column TravelSummary will be similar to the below
During this trip I visited the following offices in London,Bristol, Italy, New York and Boston
I would like to generate a graph with Dimension (Month), count the users visited selected city. Expression (A string extracted from Travel Summary) similar to the below sql statement
=count(SELECT * FROM mytable
WHERE TravelSummary LIKE '%word1%')
How do I generate expression?