I’m currently trying to get Grafana to output what is on our meter as I have to submit monthly meter readings. I currently have my total Watts, Watt hours, kilowatt hours and amps all being sent to an influxdb instance.
I also have the base number that was on the meter when the Iotawatt was connected, 45768.
Using this query gives me the proper number of kwh that has been logged by the Iota since installation and matches the energy graph in Iota’s utility so I believe it is an accurate query
SELECT integral(“value”) /3600 FROM “Total_Watts” WHERE (“iota” = ‘mudridge’) AND $timeFilter GROUP BY time(1h) fill(null)
The problem is when I start trying to add the base 45768 to it, it always ends up displaying something like 37.x MWh which is obviously not accurate.
I believe it is due to the difference in units being measured. I’m querying watts and then trying to add kwh to it? I’m not really sure how to go about this at this point? I don’t think I can use the total kwh output as looking at the data points many intervals show 0 when there is very low usage which is often.