Hello,
I have a problem generating a Chart, i use a column in a table named as Category, this column is feed by a Checkbox in a form so when is selected more than one, the values are saved separated with coma.
I want the chart show how many times was selected each category.
Example:
I have this lines
SMS, HSG
TAT,HSG
HSG
SMS
TAT
SMS
So my chart will show SMS = 3, TAT=2, HSG =3.
I have this sentence in the SQL of the chart
SELECT sum(CASE WHEN FIND_IN_SET(‘sms’, table.Category) <> 0 Then 1 Else 0 END) as sms,
sum(CASE WHEN FIND_IN_SET(‘hsg’, table.Category) <> 0 Then 1 Else 0 END) as hsg,
sum(CASE WHEN FIND_IN_SET(‘tat’, table.Category) <> 0 Then 1 Else 0 END) as tat
FROM table
But i have the error “The chart application cannot be generated. You must define the chart dimensions” even when i already select the dimensions :(
thank you for your help