4 Replies Latest reply on Mar 1, 2016 9:16 AM by Jennifer Young

    Count of a term in string

    Jennifer Young



      Trying to figure out this issue, was hoping someone here could help me out. My objective is to create a line graph tracking mentions of a term in field over time.


      The data I have is rather textual (Twitter data and the like). In there I have a field called content which contains the tweet itself. I want to be able to show how many times a term (say, "Clinton" or "Syria") appears an hour as a line graph.


      So far, I have the following Calculated field: CONTAINS([Content], "Syria"). This seems like its true false. I need an number to do what I need. Do I need an IF statement or something?


      That gets me results like the following.



      I'm probably missing something obvious here. What do I need to do differently?