Problem displaying a pie chart

[jhautefeuille]

I'm trying displaying a chart pie

SET total = SELECT COUNT(status) FROM workflow WHERE status="Télétravail" OR status="Présentiel";

SET tele = SELECT COUNT(status) FROM workflow WHERE status="Télétravail"; 
SET per_tele = ($tele * 100) / $total; 

SET pres = SELECT COUNT(status) FROM workflow WHERE status="Présentiel";
SET per_pres = ($pres * 100) / $total; 

SELECT 
    'chart'                     as component,
    'Proportion du télétravail' as title,
    'pie'                       as type,
    TRUE                        as labels;
SELECT 
    'Télétravail'               as label,
    $per_tele                   as value;
SELECT 
    'Présentiel'                as label,
    $per_pres                   as value;

But displaying is like that

I'm trying to CAST as REAL without success ?

What have I left out ?

Thank you.

[jhautefeuille]

I found the solution in the forum, which is much more elegant than my piece of code ;). I'm going to have to seriously revise my SQL ;)

SELECT 'chart' as component, 'pie' as type;

SELECT status as label, count(*) as value
FROM workflow
GROUP BY status;

[lovasoa]

Indeed, the best way to do things in sqlpage (and in sql in general) is often quite different from what imperative programming languages have taught us.

[lovasoa]

The issue in your initial code is that the value property of the chart component takes a number, and all variables in sqlpage are text strings.

SELECT 
    'chart'                     as component,
    'Proportion du télétravail' as title,
    'pie'                       as type,
    TRUE                        as labels;
SELECT 
    'Télétravail'               as label,
    cast($per_tele as float)     as value;
SELECT 
    'Présentiel'                as label,
    cast($per_pres as float)    as value;