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. [image] MySQL Ar…

connect a change node to the output of the mysql node. in the change node select the j: expression option (the j: is for jsonata) click the three dots on the right of the tab and it will open up. paste in the code from Steve's example [{ "series": ["kW"], "labels": ["kW Used Today"], …

zenofmud Split this topic 27 October 2021 12:09 7

A post was split to a new topic: How to chart two series in one graph

Topic		Replies	Views
MySQL Array or Arrays to line chart General	18	4974	18 February 2020
Inserting data in chart Dashboard database	4	532	18 December 2021
Problem getting data from mysql db to line chart General	6	316	4 October 2022
Inserting database data into a chart Dashboard	7	3103	27 June 2020
Create Chart from mySQL Data General	36	13640	9 August 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.

MySQL to dashboard chart - change function

Related topics