Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
If(WildMatch([Group Assignment],'*Fulfillment*'), 'Fulfillment', [Group Assignment])
Or just this
If(WildMatch([Group Assignment],'*Fulfillment*'), 'Fulfillment')