Recently I transitioned my home automation to InfluxDB 2 to gain experience with Influx 2 so I can also better consult my customers about it.
Before I was running InfluxDB 1.8 in a TICK stack, but professionally I have more experience with Prometheus+Grafana.
I have hooked up my electric Smart Meter to MQTT to monitor energie and gas consumption/production. It sends out measurements multiple times per minute in absolute total values.
What I would like, it to know how much energie I have used ‘today’ and compare it with ‘yesterday’ en the same day last week (so 7 days ago).
Although this is quite trivial with Prometheus+Grafana I cannot find out how to do this with Flux on a InfluxDB 2 dashboard.
- From this incrementing ‘total’ value, how to calculate the usage per day?
- And how to get this usage to ‘today so far’?