Has anyone had any luck getting total power usage for a device yesterday? For example, i have a pump and I simply want to see how much power it consumed between 00:00 and 11:59 yesterday or maybe all of last week etc… Every time I try to do this I get crazy numbers. In another forum I stumbled across someone saying:
use Integral function to calculate WH from W - first aggregation
use Sum function with daily time agggregation - second aggregation
=> 2 aggregations are required = subqueries are required = you need to switch to raw query editor in Grafana and you need to write it on your own
This makes sense conceptually, but then there is in practice. Any thoughts from anyone who has done this?