Hi! Im a beginner and still learning NodeRed. I have browsed through the forums to try to find information. However Im stuck. I have a table in the database that I want to pull some data from. each line from the database query looks like this: time: "2022-09-20T07:58:55.000Z" outdoortemperatu…

I take it you want to plot two lines, outdoor and logged? If so then the jsonata would be ( $lines := ["outdoortemperature","loggedoutdoortemp"]; [ { "series": $lines, "data":[ $lines.[($key := $; $$.payload.{"x": $.time, "y": $lookup($, $key)} …

Steve-Mcl 20 September 2022 13:01 2

You could probably adapt this dynamic routine with little ease...

1 Like

Topic		Replies	Views
Doubt with data from Mysql A NodeRed and graph it General node-red-dashboard , database , chart , mysql	8	184	14 July 2024
MySQL to dashboard chart - change function Dashboard	7	2583	27 October 2021
Charts in node-red with data from mysql database Dashboard	19	10187	11 March 2022
Dynamic series identification from message, send data to Chart Dashboard	6	2540	23 December 2020
Need help with line chart Dashboard	30	7628	16 July 2019

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.

Problem getting data from mysql db to line chart

Related topics