I want to show in a display the power consumption for the current day and for the current month.
In the influxdb I have the accumulative power consumption on each time, so what Im trying to do is to calculate the difference between the value for the power consumption at the begining of the day/month and the power consumption in the current time, and thus, get the power consumption in the period of time.
In fact, I have a bar dashboard that works fine and its as follows
This shows 2.24kWh for the current day consumption, which is correct.
The problem comes when I try to display just this current day in a display. I’m using derivative so it is supposed that the unit should be 2m because I receive this value every 2minutes (when I change this value I get a completely different value).
This should show the same value 2.24kWh
And those are the query options:
So what I’m doing wrong? I guess it is on the query options but I don’t understand what are the correct values.
Thanks in advance
