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"], …

Thanks so much, it works. I had tried copying that and editing it, but obviously I messed some of the brackets up. Time to get a book! [image]

[image] EdwardDM10: Time to get a book! Good luck with that! You've wandered into a whole new nascent world of JS Object manipulation, which seems to only be documented online. That being said, you can read the entire set of docs on the jsonata.org site in an afternoon -- well worth the price…

In fact, if you are a beginner, I suggest not getting too deep in jsonata. It is a very powerful tool for massaging data but it is not the easiest stuff to get to grips with. There is never an absolute requirement to use it, as the same task can always be done using more more straight forward tech…

after going through this thread nearly 10 times, i finally got it. thanks a lot...i almost gave up.

MySQL to dashboard chart - change function - #7 by zenofmud - Dashboard

Topic		Replies	Views	Activity
Inserting data in chart Dashboard database	4	566	18 December 2021
MySQL Array or Arrays to line chart General	18	5037	18 February 2020
Problem getting data from mysql db to line chart General	6	363	4 October 2022
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	25	3499	19 July 2022
Chart Dashboard 2.0 Dashboard dashboard-2	13	323	1 July 2024

Inserting data in chart

Dashboard

database

4

566

18 December 2021

MySQL Array or Arrays to line chart

General

18

5037

18 February 2020

Problem getting data from mysql db to line chart

General

6

363

4 October 2022

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

Dashboard

node-red-dashboard

25

3499

19 July 2022

Chart Dashboard 2.0

Dashboard

dashboard-2

13

323

1 July 2024

MySQL to dashboard chart - change function

Related topics