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