I tried to display a chart with the information gathered from a mysql database. The problem is that the mysql node returns a structure which cannot be processed by the chart node. I also tried to add a change node, but I don't know how to configure it. Please help me. [image]

It might be worth reading this... as it describes the format needed by the chart node. node-red/node-red-dashboard/blob/master/Charts.md # Node-RED-Dashboard Charts ## Live data To display live data just wire up an input with a `msg.payload` that contains a number. ### Line chart…

Thank you for reply. The query is doing its job. My problem is how the data is displayed. I would like, first of all, to be able to display number, not a tree of arrays like below. [image]

Thank you for reply. I read this article. The problems it that I don't have any idea about how to convert the returned text. I don't master js.

I think you need to do what @zenofmud suggested, as that will enable people to help your further. I noticed you have changed from using a chart node to a table node - was that intentional?

Yes. I wanted to check out if the data from the table is fetched correctly.

Here's another link with an example (which I think is similar to what you are trying to do). [image] Create Chart from mySQL Data General Can you post a debug showing the message you send to populate the chart please? Make sure all the objects are expanded.

I can see the problem. I do not know how to print only the value of the last record, without the surrounding metadata (msg arrary[1] etc). Can you help me please? I do not know very much about javascript. I do want to get only 22 (the case of the ss above), not "array[1]:object:temperatura_medie".

If you scroll down to the end of the first link I posted, there are some Chart examples. [chart_exgs] It would help if you shared your flow and a sample of the output from you dB.

I don't know how to share my flow. I am new to NodeRED.

[image] pauk: I do want to get only 22 (the case of the ss above), not "array[1]:object:temperatura_medie". You could try... msg.payload = msg.payload[0].temperatura_medie; Feed that into a debug node and see if that gives you 22.

Node-RED

Node-RED Forum

How could I display data from a mysql database within a chart?

Dashboard

dynamicdave 17 June 2022 10:06 8

Here's another link with an example (which I think is similar to what you are trying to do).

Topic		Replies	Views
Query MySQL and displaying it in a dashboard Chart General	8	1199	3 May 2021
Charts in node-red with data from mysql database Dashboard	19	11217	11 March 2022
How can I show the chart from my data? General	12	373	19 June 2023
Create chart reading data from database Dashboard	20	2097	12 November 2020
I need help, chart-ui from select sql server Dashboard	34	2007	7 June 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How could I display data from a mysql database within a chart?

Related topics