SQLpage icon indicating copy to clipboard operation
SQLpage copied to clipboard

Graph doesnt display data

Open alexisrc1 opened this issue 7 months ago • 1 comments

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

image

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.

alexisrc1 avatar Jul 08 '24 10:07 alexisrc1