2 Replies Latest reply: Apr 27, 2017 12:52 PM by Sunny Talwar RSS

    Consolidation of Chart Values

    James Smith

      I have data in a table that I'm trying to count the number of times a word occurs  and chart those. The date looks like this

       

      Managed Services

      Deployment Services;#Managed Services;#RFP

      Deployment Services

      Fulfillment Services

      Deployment Services;#Fulfillment Services

      Fulfillment Services

      Fulfillment Services

      Fulfillment Services

      Fulfillment Services

      Healthcare;#Professional Services

       

      If I chart using

       

      if(WildMatch([Group Assignment],'*Fulfillment*'),[Group Assignment])

       

      It gives me a column for each unique entry that contains the word Fulfillment, what i'm trying to get to is a single column that shows me a count of every entry that contains the word Fulfillment instead of splitting them out.