Hi everybody, it seems pretty easy but I found very difficult to calculate various value of my daily consumption. Im using InfluxDB and latest version of Grafana along with a Shelly EM. The data I received are inconsistent (the shelly EM use MQTT protocol to send the data and It doenst send it every X second but it send randomly (more or less 10-15 per minute) The power comes in Watt. Now I just want to obtain:
- The MIN, MAX and CURRENT value in the $_intervall period
- The daily cost
- The monthly approx usage cost
- The cost per day in a month graph
This is what I got
At the bottom it says min 47Watt and that is precise in my graph at the top it said 85Watt and it isnt correct, this is the influx query:
SELECT min(“value”) FROM “power” WHERE $timeFilter GROUP BY time(1d) fill(none)
This is 24H power usage
SELECT sum(“value”) FROM “power” WHERE $timeFilter GROUP BY time($__interval) fill(null)
This is average home consumption
SELECT mean(“value”) FROM “power” WHERE $timeFilter GROUP BY time(1m) fill(null)
This is daily power cost
SELECT mean(“value”) /1000240.22 FROM “power” WHERE $timeFilter GROUP BY time($__interval) fill(null)
This is estimated monthly power cost
SELECT mean(“value”) /10003024*0.11 FROM “power” WHERE $timeFilter GROUP BY time($__interval) fill(null)
Finally the cost per each day graph and this is totally broken
(Due to new users I cant upload more than 2 images sorry)
Can someone help me to find out the correct formula? Thank you
Also im struggling understanding the GROUP BY, because Im not sure what it return back when I used it. In theory it should give me, in the case it is group by time(1d), a dew group that contains the all 1day results