Hi guys, not sure "General" is correct forum branch, maybe "Dashboard" fits better for the question. I am building UI for She-bear - a monitor and sentinel of house water consumption. Of course, I'll post stable version in "Share your project" eventually. Meanwhile, I need to sum consumption (in l…

I would start with persistence: a database. Something relatively simple like sqlite . Store the MQTT data in there. Once that is working, dashboard is next.

[image] bakman2: I would start with persistence: a database. Definitely, but you should also consider InfluxDB. Either will give you lots of ways to "slice and dice" the data before displaying it on a dashboard. You won't be restricted to a fixed time frame such as the calendar month. You can…

[image] drmibell: you should also consider InfluxDB Got it. Struggling since yesterday to couple InluxDB -> Grafana -> template UI. No problems with grafana. Tons of problems with influx. Solved influx not opening port 8086 (many people complain on the Internet). Next barrier is create user.…

[image] igrowing: reasonable step-by-step guide/tutorial Everything I know about InfluxDB I learned from Andreas Spiess: [#255 Node-Red, InfluxDB, and Grafana Tutorial on a Raspberry Pi]

I use the so called TIG stack; (telegraf, influxdb and grafana), Comprehensive tutorial for installation.

Please, help with programming. InfluxDB requires all fields and values as msg.payload object. So I need to gather few messages with different topics and values into one object. I try to do that using context. /*Input: msg.topic="Phase 0", msg.payload="123"*/ var num_params = 3; context.set(msg.to…

Started with Join, of course. It doesn't do the job of connecting several messages with topics and payload into single object {topic1: payload1,topic2: payload3,topic3: payload3... } Or I didn't understand hot to set the node...

Can you give some example input (some more than in the function above).

messages arrive with topics and payloads: (topic: payload) Power 0: 123 Power 1: 345 Power 2: 567 etc. Copy from debug window of one such message: object topic: "Phase 1" payload: "7058" I need an output message payload as object: {Power_0: 123, Power_1: 345, Power_2: 567}

Node-RED

Node-RED Forum

Summing all msg.payload in a month

General

igrowing 4 August 2019 05:53 16

Thank you. It works!

Sum up three outputs from mqtt

Topic		Replies	Views
Multiple topics to one influxdb mesurement General database , function-node , mqtt	12	404	27 August 2023
Help Optimize MQTT to influx functions Share Your Nodes	10	2590	31 January 2020
Process MQTT-data time triggered Dashboard	5	770	14 November 2020
Mqtt -> Node-Red -> InfluxDB General	6	2236	25 April 2020
Import MQTT to Influxdb General	11	536	14 April 2023

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.

Summing all msg.payload in a month

Related topics