Announcement

Collapse
No announcement yet.

Chart problem with SQL!

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Chart problem with SQL!

    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
Working...
X