# Chart-Node - Can't get chart from database data

**URL:** <https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203>\
**Category:** Dashboard\
**Created:** [14 February 2023 21:56 UTC](https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203 "2023-02-14T21:56:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mssib28](https://avatars.discourse-cdn.com/v4/letter/m/d2c977/32.png) [@mssib28](https://discourse.nodered.org/u/mssib28)\
**Post date:** [14 February 2023 21:56 UTC](https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203/1 "2023-02-14T21:56:34Z")

</div>

Hi together,  
I try to get data from a MariaDB into a chart-node.  
As an example I used the information given at [MYSQL Example](https://flows.nodered.org/flow/13c55d1aa11e864609e24fa534a1fa26).  
I don't find the mistake, why no data are displayed.  
My actual flow, as well as the debug outputs are  
[flow\_Maria\_chart.json](https://discourse.nodered.org/uploads/short-url/5k4AZQoH7inTByvbRWzY7aHYG03.json) (4.9 KB)  
[format data\_output.txt](https://discourse.nodered.org/uploads/short-url/pAZX9vglosaDosJ8HpmN92Isytr.txt) (710 Bytes)  
[mysql\_output.txt](https://discourse.nodered.org/uploads/short-url/3fz3F17sXiJ3s39X06tvxGC2RJ.txt) (687 Bytes)  
attached  
Maybe somebody can give me a tip, where the mistake is.

Thank you very much in advance  
Regards

Martin

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [14 February 2023 22:14 UTC](https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203/2 "2023-02-14T22:14:13Z")

</div>

Compare your data with the format described for line charts in [node-red-dashboard/Charts.md at master · node-red/node-red-dashboard · GitHub](https://github.com/node-red/node-red-dashboard/blob/master/Charts.md) and you will see there are several discrepancies.  
`series` should be an array.  
The data must be in an array of arrays and should be called `data`.  
Your timestamps look to be 1000 times too small. I suspect they are seconds rather than milliseconds.

---

<div class="post-metadata">

**Author:** ![mssib28](https://avatars.discourse-cdn.com/v4/letter/m/d2c977/32.png) [@mssib28](https://discourse.nodered.org/u/mssib28)\
**Post date:** [15 February 2023 20:31 UTC](https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203/3 "2023-02-15T20:31:37Z")

</div>

Colin,

thank you very much for your support.  
I will check soon.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [17 March 2023 20:32 UTC](https://discourse.nodered.org/t/chart-node-cant-get-chart-from-database-data/75203/4 "2023-03-17T20:32:18Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.