AnsweredAssumed Answered

Converting multiple values in one text field to a chart

Question asked by mslater14 on Jan 6, 2019
Latest reply on Jan 7, 2019 by mslater14

Hello,

I need some help converting my data from multiple values in one text field into a chart. Firstly, I have split my fields allowing me to enter multiple answers in a single field as below:

 

CAT 2.png

However, I need to convert these answers into a chart and currently its recording “cats” twice as it’s the first answer I have entered, when actually it should be 1 count of 'cats' and 1 count of 'dog'. Does anyone know how to rectify this?

Cat1.png

 

Thanks in advance

Outcomes