Inserting data in chart

[Jesse052002]

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

[smanjunath211]

MySQL to dashboard chart - change function

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. [nodered] 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

[Jesse052002]

Okay thanks, I will have a look at it

[smanjunath211]

How to really get data into a Node-RED bar chart from a database table - the JSONata way.

also look into this.