Question about Check Box / Multi Select
I have a checkbox with, for sake of example, the following information:
Apple
Pear
Orange
And for each person, I want to track which fruit they like... so:
Johnny: Apple
Bobby: Apple, Orange
Susie: Apple, Pear
... and then I'm trying to import this data into Zoho's DB's to produce a report (no problem doing this), but then show a pie chart of how many persons like Apples, Oranges, and Pears...
Therefore with this data, I would have a pie chart of 3 counts for Apple, 1 for Orange, and 1 for Pear.
What is happening is that the pie chart is considering:
Apple
Apple, Orange
Apple, Pear
... all as one long string, or value. So we then have the pie chart split into 3 equal areas, being "Apple", "Apple, Orange", and "Apple, Pear". Please help!