Problem with sql sentence

Hello,
Please share your backend & FTP login credentials via Contact us form, We'll look into it.

Ye, of course.

I'm making a new chart.
Data are in table but is imposible with options read correct data. Then I have to write sql sentence.

This. sql is running OK in mysql but no in vchart WHY??

SELECT (CASE WHEN p1_ret_realizados < 8 THEN 'Menos de 8 Retos' WHEN p1_ret_realizados >= 8 THEN '8 o más Retos' END) as tipo, count( p1_ret_realizados) as valor FROM hs_historico_datos where co_estadistica=1 and p1_ret_realizados != "" group by tipo order by tipo

VChart change case 1 "<8" for "=8" and delete case ">=9"

I need this sql but i you think that is posible do it using other way tell me. please.

Hi,
couldn't understand what you actually mean. Can you please explain the problem you are having?

Pardon in sql sentence can not change NOT equal.

Look

SELECT (CASE WHEN p1_ret_realizados < 8 THEN 'Menos de 8 Retos' WHEN p1_ret_realizados >= 8 THEN '8 o más Retos' END) as tipo, count( p1_ret_realizados) as valor FROM hs_historico_datos where co_estadistica=1 and p1_ret_realizados != "" group by tipo order by tipo

The problem is <8 and >= 8

Hi Denise

You have to use not equal option in sql query writing section. I have explained in attach image.

Thanks
Zaheer