hi all, I had been contemplating a couple of times, how other users address the issue of "visualising long term trends.". I kind of have even difficulty to properly describe what I am looking for as trending, logging and archiving seem to have different meaning to different people. My background i…

Grafana all the way . It is easy to setup and has great/flexible visualisations.

+1 for Grafana. With Influxdb for the data.

If you are not afraid to make your hands dirty with a bit of coding - take raw uPlot with your favoriite database and you can fine-tune everything. Next choice will be well know grafana route...

I keep data acquisition and storage separate from display and analysis. The database is Mariadb. I've tried Influxdb and mongodb but I use several views and calculated data within the database and found they were not as flexible as a proper SQL database, or else required different syntax. For dis…

calculated data within the database What you mean with this statement ? SQL database is used for relational general purpose data. Mongdb is a database based on (json) documents and is schema-less also general purpose. Influxdb is specifically build for timebased series and combines the 2, it i…

Well here's a snippet of a query that does calculations in the database. Not recommending it, it's just one way I use Mariadb SELECT blah, blah, ROUND(100 * (((h.offkwh - h.onkwh)1000 - m.minp)/ (m.maxp - m.minp))) as pestimate, ROUND(100(time_to_sec(timediff(h.offtime, h.ontime)) - m.mint)/(m.m…

This is slightly off-topic. Do you have an example for real-time data display using uPlot? The line chart from dashboard is too slow for real-time data display. We may have to get hands dirty :sweat_smile:

[image] davidz: This is slightly off-topic. Do you have an example for real-time data display using uPlot? [image] hotNipi: But if I can find a bit time tomorrow, I can make an example.. Hmm... :thinking: hasn't anybody shared any still?? Of course it has been done :slight_smile: …

[image] davidz: The line chart from dashboard is too slow for real-time data display Can you describe what you are trying to do and in what way the chart is too slow?

Replaying to myself to just clarify - the charting is not only and is far from being best tool for long term process analysis. It may be easiest to set up but hardest to read and slowest in the path from data to solution. Having computer in your hand which can make rocket to fly and land and get ba…

Node-RED

Node-RED Forum

What do people use for "long term trending and visualisation"?

General

hotNipi 26 September 2021 19:57 9

Of course it has been done

Topic		Replies	Views
How to review trends in the chart of previous days Dashboard	3	892	7 August 2020
Database - Help / Advice Needed General	15	406	23 December 2022
Persistent chart node Dashboard	3	1453	12 May 2021
General Question to experts General	2	228	16 June 2023
Longtime Charts Dashboard	3	617	5 October 2018

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.

What do people use for "long term trending and visualisation"?

Related topics