Help

How can I count each selection on a multiple select field?

1939 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Renee_DeVincent
4 - Data Explorer
4 - Data Explorer

Have a case management system that I need to track monthly & yearly numbers. Can’t figure out how to get a total of each selection per year & month. I can only get total no way to get per month/day. Here is an example:

Client A seeks help on “Date of service” has multiple “Needs” then we refer them to multiple “Service Providers”.

I need to know per Year & Month:

How many Clients for Need 1, Need 2, Need 3 (multiple select field)
How many referrals to Service provider 1, Service Provider 2, Service Provider 3 (multiple select field)

Converted date to separate Month & Date. Was able to get for year Month/year all the occurance of each year/month. But how do you count TEXT separated by commas? HELP! ANYONE!

Here is a screen shot of my table Screen Shot 2017-04-05 at 2.21.15 PM.png

1 Reply 1
Renee_DeVincent
4 - Data Explorer
4 - Data Explorer

I also tried separating out Need and got in a field all the occurrences of year/month, but again how can I count text separated by commas. Surely there is a way to do this.Screen Shot 2017-04-04 at 12.53.27 AM.png