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	3	572	18 November 2021
MySQL Array or Arrays to line chart General	18	5075	18 February 2020
Problem getting data from mysql db to line chart General	5	375	20 September 2022
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	24	3564	19 June 2022
Chart Dashboard 2.0 Dashboard dashboard-2	12	346	17 June 2024

Inserting data in chart

Dashboard

database

3

572

18 November 2021

MySQL Array or Arrays to line chart

General

18

5075

18 February 2020

Problem getting data from mysql db to line chart

General

5

375

20 September 2022

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

Dashboard

node-red-dashboard

24

3564

19 June 2022

Chart Dashboard 2.0

Dashboard

dashboard-2

12

346

17 June 2024

MySQL to dashboard chart - change function

Related topics