i have sensor that append the total KWh every hour to influxDB
SELECT last(“value”) FROM “energy” WHERE (“id” =~ /^id/) AND $timeFilter GROUP BY time(1d)
this give me the total accumulated value everyday
i need to substact the yesterday value to get the consumption of the day… Im unable to do that.
Can someone help me?
I need to see total consumption by Day
todayKwh = today(last) - yesterday(last)