Load mySQL data to Dashboard Graph

Henjoe · 3 November 2019 17:08

Dear Node-Red users, is anyone here already load of time series data from an SQL to Graph dashboard? Let say I have a date time picker in my UI, if the user select specific date, it should load specific data from that date into a graph. I can't see any good examples regarding here. Any suggestions how am I going to deal with it? Thank you very much!

ukmoose · 3 November 2019 17:11

This page should give you the format you require, it’s linked from the node-red-dashboard nodes readme

github.com

node-red/node-red-dashboard/blob/master/Charts.md

# Node-RED-Dashboard Charts

## Live data

To display live data just wire up an input with a `msg.payload` that contains a number.


### Line charts

To display two or more lines on the same chart then each `msg` must also contain `topic`
property that identifies which data series it belongs to - for example:

    {topic:"temperature", payload:22}
    {topic:"humidity", payload:66}

Each series will be represented by a different colour.
Alternatively you can use the property `series` instead of `topic` if you prefer.

It is possible to create "gaps" in line charts by sending either a null or boolean false as the payload.

This file has been truncated. show original

Henjoe · 3 November 2019 17:13

Your awesome dude !! Thank you very much ! This is what I am looking for !

Topic		Replies	Views
Dashboard - line graph - show datapoints from database Dashboard node-red-dashboard , database	16	749	11 October 2022
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	25	2798	19 July 2022
Inserting data in chart Dashboard database	4	511	18 December 2021
Data from MySQL db to Graph Dashboard	16	1647	2 December 2020
Dashboard line chart not working Dashboard	3	1633	1 June 2020

Load mySQL data to Dashboard Graph

Related topics