SQLpage
SQLpage copied to clipboard
Graph doesnt display data
Introduction
While the data exist and seems to be formatted correctly, no data apperas on the graph
To Reproduce
here is a data sample:
series | x | y 2024 | 08 | 1378.52 2024 | 09 | 4987.839999999999 2024 | 10 | 14099.9 2023 | 10 | 3886.4200000000005 2024 | 11 | 11128.019999999999 2023 | 11 | 9229.219999999998 2023 | 12 | 12063.259999999995 2024 | 12 | 24815.0 2023 | 13 | 8767.86 2024 | 13 | 12267.899999999996 2023 | 14 | 10196.460000000003 2024 | 14 | 23070.420000000002 2024 | 15 | 13350.87 2023 | 15 | 31956.820000000007 2023 | 16 | 53994.23000000004 2024 | 16 | 15837.699999999997
the table component does display the data above:
SELECT 'table' as component;
SELECT year as series,hour_included as x, sum(netto_incl_eur) as y
from data_live_facture
group by year,hour_included
order by hour_included asc;
but this doesnt display anything:
select
'chart' as component,
concat('Live data CA') as title,
'area' as type,
'indigo' as color,
5 as marker,
0 as ymin;
SELECT year as series,hour_included as x, sum(netto_incl_eur) as y
from data_live_facture
group by year,hour_included
order by hour_included asc;
Actual behavior
After following these steps, what happened ? If you saw an error on the command line or inside your page, then paste it here
your error message here
Screenshots
Expected behavior
A clear and concise description of what you expected to happen.
Version information
- OS:
- Database [e.g. SQLite, Postgres]
- SQLPage Version [found when hovering the default footer of pages]:
Additional context
Add any other context about the problem here.