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	529	18 December 2021
MySQL Array or Arrays to line chart General	18	4955	18 February 2020
Problem getting data from mysql db to line chart General	6	308	4 October 2022
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	25	3133	19 July 2022
Chart Dashboard 2.0 Dashboard dashboard-2	13	240	1 July 2024

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