WTH isn't the "adjust a statistic" developer tool easier to use

Month of "What the heck?!"
1

I find I’m somewhat regularly going into the adjust a statistic tool (developer tools > Statistics > rising line icons on the right) to correct weird errors in my energy data and this tool is very frustrating to use. I am typically scanning for outliers over a specific time period and it it very hard to do this as you need to keep inputting new dates and times, and heaven forbid you accidentally hit enter after typing something in and you exit the tool and have to start over.

Things that would make this so much better:

  1. allow a filter to be applied to the outliers. Right now this gives you the outliers for all of the data and often that doesn’t include the errors I’m looking for. If I could ask home assistant to look for outliers over the past hour or day or week or month that would help find these issue so much faster.
  2. Show more records in the view / allow the view to be expanded.
  3. Include arrow buttons to jump forward and back one time period. For most statistics it shows a data point for every 5 minutes, and the tiny card only shows you 5 records so I find my self adjusting the time by 15 minute increments in hopes of trying to find the outlier, all the time trying to keep my hands from hitting enter after typing in a number.
  4. The holy grail would be after you find an outlier and you have decided to mannually override the data for a specific date and time, if the input field would include 5-10 data records from both before and after the time period you are adjusting. This would help greatly in picking an appropriate aproximate value to input.

I’m just trying to keep my graphs beautiful!

2

While an agree the tool does need some tweaks the real,“holy grail” is to fix your energy sensors so you don’t need to use the tool. Nine times out of ten this can be done with an availability template.

3

Can you please explain what you mean so I can fix this?

4

When an energy sensor goes unavailable it should report its state as unavailable, not 0.

There’s a guide here Why an availability template is important for energy template sensors

5

I get the most issues with integral helpers. The original source information is power (watts) from a combination of Iotawatt, ESPhome, and powercalc sensors. I also have a bunch of calculated sensors that group the power sensors into rooms and floors of my house. Then I feed those into integral helpers to get the kWh figures for everything. Somewhat regularly I get errors in the kWh figures from what I guess is what you described in your other post but I’m not sure how to fix it.

I do try to use energy sensors from the source devices (iotawatt, esphome, & powercalc) where available but not all of them provide this.