Integrate per day gives wrong result for today

[Francis Pagé]

Hi,

I'm still learning how VM works, so it may be a stupid question. I log my house power usage every one or two seconds and I'm trying to get the total energy used per day. I'm using Grafana and I was able to get what I want, except that it gives wrong results for the current day.

Here's how it looks:

I used "now-3d/d" as relative time, so I can get the last 3 days. To include today, I used an offset of -1d in the query. Finally, I set the min step to 1d. Does it make sense?

I think the wrong value for the current day is because there is no data for the remaining time of the day and VM seems to be using the last known data for all the future points. I tried to use the "default" operator to fill with 0, but it gives wrong data for all the days (I'm not sure I understand how to use it in combination with an integral).

So, what am I doing wrong? Is there a way to get the right energy value for the current day?

Thank you!

Francis