first of all thank you for the great forum and community here. I could already inform me strongly.
But at the moment i am a little bit confused.
I’ve been thinking about this for about a week now. Hope you can give me some thoughts about this.
I would like to measure the consumption of various devices in our company. For this we have relied on Shelly3EM, which also works quite well.
I am using MQTT and NodeRed to retrieve the values and write them to the Influxdb.
For the time being, we are talking about 5 machines. Tendency increasing.
At the end I would like to reach naturally also a total value of all machines/consumers.
In the meantime, however, I come to more and more challenges, whereby I already doubt my scheme.
The Shelly delivers the “total value” per phase.
I have to aggregate this three phases and calculate the total consumption per device with the “last” value.
I want to downsample the values. For this I have created different buckets. “ds-1m, ds-1h”, ds-1d", ds-1mo", ds-1y".
How can I differ to downsample different values the “mean” and with others the “last” value?
I want the “last” value of the “total_wh” but the “mean” of “voltage”.
How can I archive this?
Is it better to store the values as for example
Have a lot more questions about monthly/yearly charts in grafana, but let us start at the beginning.
Thank you very much!