Hello, I use Node-Red with the Shelly 3 EM energy meter. I can display the data in the dashboard via MQTT.
Question/ Problem: I write the data to the Influx DB database every 3 seconds.
I can then read them via: query ..msg.query=selct * ........ and display them in the dashboard.
Problem: I understand how to query values for the last minute...hour.
But how is the query: if I want special days or a whole month. Example: a month that was many months ago.
Do I first have to create/write hourly values in the Influxdb .. every 1h (how does that work) and then create the daily values from the hourly values?
I would like to always evaluate my energy values for a month (summarize)
Sorry for my bad English but I've been looking for solutions in German forums for weeks.