# Doubt with data from Mysql A NodeRed and graph it

**URL:** <https://discourse.nodered.org/t/doubt-with-data-from-mysql-a-nodered-and-graph-it/87256>\
**Category:** General\
**Tags:** node-red-dashboard, database, chart, mysql\
**Created:** [15 April 2024 18:35 UTC](https://discourse.nodered.org/t/doubt-with-data-from-mysql-a-nodered-and-graph-it/87256 "2024-04-15T18:35:08Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [15 April 2024 20:45 UTC](https://discourse.nodered.org/t/doubt-with-data-from-mysql-a-nodered-and-graph-it/87256/4 "2024-04-15T20:45:00Z")

</div>

Although you have debug nodes in your flow you have not shown us what they output, so we are guessing.

However, maybe this post will be helpful:

> [@Convert object from sqlite to use in line graph](https://discourse.nodered.org/t/convert-object-from-sqlite-to-use-in-line-graph/85906/2):
>
> Assuming that you are using node-red-dashboard v1... You need to send your data to the chart node in a specific format: An array containing a single object with properties "series", "data" and "labels". "series" is an array of the names of lines on the chart. For a single line, just one element in the array. "data" is an array of arrays, one array per line on the chart. Each array element is an object with x and y properties to define the points on the line. "labels" - Actually I'm not sure …

---

_[View the full topic](https://discourse.nodered.org/t/doubt-with-data-from-mysql-a-nodered-and-graph-it/87256)._