The problem with the (negative) water consumption 🚰

[orange-assistant (the real one)]

So made changes to my esphome based flow meter so I can integrate it into the energy dashboard - that said and done it works

The problem is the following, looking closely when I set up the energy dashboard to track water consumption (last sunday) it has a huge negative value

I tried to “fix” the value in the development tools under statistics but couldn’t find the wrong value at all. Also looking at the source sensor configure in the energy tab for tracking the water consumption - it does not have that (negative) value.

Also removing the tracking of water in the energy tab configuration - waiting some hours and adding it back didn’t fix the problem.

This is the history of the value that tracks the water consumption (had to fix something because consumption was reported 10 times higher then expected - did this directly in esphome).

The thing is we will not use that amount of water in our life time so it will be wrong forever summing up (monthly/yearly…)

[Edwin_D]

@orange-assistant

but couldn’t find the wrong value at all.

Finding it takes some effort as the list where you can find the wrong value only shows a very limited range, so use history graph to pinpoint the exact time, and then check around that period.

[orange-assistant (the real one)]

Now creating all the screen shots I found one odd thing

The developer tools report the statistics unit as “m³”

But clicking on the entity the unit of measurement is reported as “L”

Still not sure how that would cause negative values at all

@Edwin_D

use history graph to pinpoint the exact time, and then check around that period.

I did this, and the only spot extra ordinary seems to be when the esphome water meter restarted - but that always was handled gracefully and without issue in the past

[orange-assistant (the real one)]

@Edwin_D

Finding it takes some effort

Yes! Was well hidden but finally found it! Thank’s