Hello,
I was wondering if its possible to generate a pie chart based on a certain way data is stored in my database.
I have this table tbl_choices, with the field Categories.
The categories field is populated from an entry form with checkboxes. It stores the value of the form items that are checked. For example, if the Categories on the form that are selected are Cat, Dog, Mouse, Rat, Goat. It stores it in the database field Category as "Cat, Dog, Mouse, Rat, Goat".
Now my question is, for each tbl_choice, I need to generate a pie chart with the number of occurences of each Cat, Dog, Mouse, etc.
Is this possible? There's no way to change the database, as there is simply way too much data.
Thanks
I was wondering if its possible to generate a pie chart based on a certain way data is stored in my database.
I have this table tbl_choices, with the field Categories.
The categories field is populated from an entry form with checkboxes. It stores the value of the form items that are checked. For example, if the Categories on the form that are selected are Cat, Dog, Mouse, Rat, Goat. It stores it in the database field Category as "Cat, Dog, Mouse, Rat, Goat".
Now my question is, for each tbl_choice, I need to generate a pie chart with the number of occurences of each Cat, Dog, Mouse, etc.
Is this possible? There's no way to change the database, as there is simply way too much data.
Thanks