2 Replies Latest reply: Jun 1, 2016 9:30 AM by Aurélien Martinez RSS

    How do I convert the following SQL Statement to an expression?

    Ram S

      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?


      Thank you