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
Inserting data in chart Dashboard database	4	512	18 December 2021
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	25	2847	19 July 2022
MySQL Array or Arrays to line chart General	18	4929	18 February 2020
How can I show the chart from my data? General	13	276	18 August 2023
Data from MySQL db to Graph Dashboard	16	1658	2 December 2020

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