Problem calculating power consumption from its acumulative value

Grafana InfluxDB
1

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

image
image1365×752 62.4 KB

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

image
image1216×750 86.8 KB

And those are the query options:

image

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

2

Welcome @ximyb5

Can you try changing the query options to these and see if that helps?
image

3

Hello! thanks for the reply.

I changed my query option but i has no change.

image

I have set the difference on the calculation and looks like more close to the real value.

image