# Inserting data in chart

**URL:** <https://discourse.nodered.org/t/inserting-data-in-chart/53930>\
**Category:** Dashboard\
**Tags:** database\
**Created:** [18 November 2021 10:35 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930 "2021-11-18T10:35:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jesse052002](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@Jesse052002](https://discourse.nodered.org/u/Jesse052002)\
**Post date:** [18 November 2021 10:35 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930/1 "2021-11-18T10:35:17Z")

</div>

Heyy,

I got a question about my node red project. The project requires to pull data from a MYSQL database.  
Right know I can pull the data and show it in my debug and system console. (see the pics)

But i cant show it in a data chart, Tried to look it up on YT but couldn't find anything.!

[Node-red|690x126](https://discourse.nodered.org/uploads/short-url/6jYeQhcEds16iMLpbKbLjiPzS5i.png)  
 ![Knipsel](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/1/41bcf24563c7165e7917479f19febdc1713b267e.png)

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [18 November 2021 10:43 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930/2 "2021-11-18T10:43:16Z")

</div>

> [@MySQL to dashboard chart - change function](https://discourse.nodered.org/t/mysql-to-dashboard-chart-change-function/14418):
>
> This will be a newbie question, so please bear with me... I have a MySQL database with a test schema in. I can read and write to it using node red. So far so good. I gather that to get the information in to a chart I have to use the 'change' function. However, I just can't wrap my head around how to make it work. I have zero background in JS. Would anyway one able to point me in the right direction? My test schema uses id (int) Value (real) and Timestamp (DT) My test query bri…

This post helped me to get MySQL to Chart going. may be it will help you too,  
if you share the code, may be i can give it a try

---

<div class="post-metadata">

**Author:** ![Jesse052002](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@Jesse052002](https://discourse.nodered.org/u/Jesse052002)\
**Post date:** [18 November 2021 10:46 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930/3 "2021-11-18T10:46:49Z")

</div>

Okay thanks, I will have a look at it

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [18 November 2021 11:20 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930/4 "2021-11-18T11:20:58Z")

</div>

[![](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/0/f0e8141caad5ab527c40c2c5a043640b3989083d.jpeg "How to really get data into a Node-RED bar chart from a database table - the JSONata way.") ](https://www.youtube.com/watch?v=qqoj7g5CR1g)

also look into this.

---

<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:** [18 December 2021 11:21 UTC](https://discourse.nodered.org/t/inserting-data-in-chart/53930/5 "2021-12-18T11:21:03Z")

</div>

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