Good day colleagues, I have a question, it turns out that I am trying to extract data from the MySql table, and make a push to graph it in a chart, all with a date range, it turns out that it does not give any error somewhere in the code but at the same time See my chart, it is not graphing anything…

Thanks, I'm going to read the example topic you sent me and see how I can implement it.

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: [image] Convert object from sqlite to use in line graph General Assuming that you are using node-red-dashboard v1... You need …

Oh sorry, I didn't realize that I missed adding the debug, these are, debug 43 is the one that I understand does not give the correct format for the chart, I'm still trying to graph my Mysql data in a node chart network, but none of them graph me hehe, it has been something difficult. [debug]

If you run your data through the flow I pointed you at you would see the data should be an array of arrays of objects. Yours is an array of objects. Alternatively, follow the info in the docs

To add to Steve's comment, msg.payload[0].data should be an array containing an array/s of objects, while you just have an array of objects.

ooo, that is, it should be a specific json to be able to graph the group of data I want, or am I wrong?

Doubt with data from Mysql A NodeRed and graph it

General

Steve-Mcl 15 April 2024 18:47 2

I'm not at a computer to load your flow but it looks like you haven't provided any sample data anyway (which makes it difficult for anyone to help you) but here is a universal flow that might help: Dynamic series identification from message, send data to Chart - #5 by Steve-Mcl

Topic		Replies	Views
How can I show the chart from my data? General	12	375	19 June 2023
MYSQL database to chart Dashboard	2	807	22 March 2021
Inserting data in chart Dashboard database	3	566	18 November 2021
Create Chart from mySQL Data General	36	13792	9 August 2021
Charts in node-red with data from mysql database Dashboard	19	11227	11 March 2022

Doubt with data from Mysql A NodeRed and graph it

Related topics