I have some solar panels and using some esp32 stuff, I got a value every 30 minutes which represents the average of the generated power during the last 30 minutes time period.
Hopefully you understand what I mean.
So for example in a time range from 8-10 o’clock, I get 4 values, e.g.:
These are the values, which are permanently written into my InfluxDB and with which I have to deal with.
So that means, if I sum up these values (600W) and divide them through the time, I should get 300Wh.
My goal sounds pretty easy. I want to display just the value of all Wh which my solar panels have collected. So I have to do some calculation in a grafana query, I think. Or not?
The result do not have to show a specific time period (it could, but it do not need to). I am interested in the sum of every generated Wh during the whole year.
Can anyone help me?
I am not able to do this SQL query by myself.