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

    Count of a term in string

    Jennifer Young

      Hi,

       

      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?