Hi, im trying to get a chart with 7 lines comming from 7 variables from SQL, if i get only 1 variable all is fine in the chart, but if i want 2 or more variables/lines in my chart its imposible to get, someone knows how to do? I did it in Change node: [{ "series": ["DepAvg"], "labels": [""], "data": [[payload.{ "x": ."Fecha", "y": ."ExtAvg" }]] }] Thanks

Feed the output into a change node and compare what you see with the requirements from the docs.

sorry Colin, but i dont understand what you want to say my problem is how can i put more lines "y" in my chart from my SQL data

Thank you so much Steve, this is exactly what i need, working perfect now

Node-RED

Node-RED Forum

SQL date to chart

General

Steve-Mcl 1 December 2020 10:40 4

@MA.ING you could use this solution as a starting point.

Topic		Replies	Views
Multiple line chart from SQL Dashboard	0	538	9 June 2020
Data from mySQL to Chart General	8	3991	23 May 2019
Ui-Chart Dashboard V2 - Multi-line line chart from SQL data Dashboard ui-chart	6	633	12 November 2025
Help displaying two lines on a chart from SQL data Dashboard	1	339	10 June 2021
SQL data and chart node General	1	518	22 April 2019

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.

SQL date to chart

Related topics