4 Replies Latest reply on Jan 21, 2013 1:10 PM by Chris Smith

    Grouping and calculated fields

    Chris Smith

      Greetings,

       

      Appreciate any help that can be offered. I'm trying to take search terms that are used to find my company's website and group them. Instead of doing this manually (there are a lot of search terms), I would like to use calculated functions so I don't have to create new groups every-time I add more data.

       

      With the CASE and IF functions, is there a way to group search terms by whether they contain a certain word. For example,

      how would I go about grouping the term "bag" for the following search terms so I can also pick up other words used in the search query? If I use the CASE function, I will only see search results for "bag" and not shopping bag, green bag, bag that is waterproof, etc.

       

      Search TermQuantityDate

      bag

      31/1/13

      shopping bag

      1

      1/1/13

      green bag

      2

      1/1/13

      bag that is waterproof

      5

      1/1/13

      lost my bag

      6

      1/1/13

      refund policy for mesh bags3

      1/1/13

       

       

       

       

      Thanks!

      Chris