New user here. Just got my IotaWatt installed and pumping data to my existing influx/grafan install. I got watts and amps logging but set up a uploader for watthours.
I’m trying to figure out how I can use that to display usage by day / week / month, etc. And maybe even calculate a cost to it.
Am I correct in thinking I can just use sum with what Iotawatt is sending? (Wh = MainFeed1 + MainFeed2)
I was thinking something like this on a bar chart for day / week / month, etc.
SELECT sum(“value”) FROM “MainWattHours” WHERE $timeFilter GROUP BY time(1d) fill(none)