Hello there
Is there a way to delete a single day out of the Energy History?
I have no idea what exactly happened there but I really would like to delete this.
2 Likes
TiagoRoxo
February 16, 2022, 3:00pm
2
I have the same need. Yesterday I have been playing with my Shelly EM and not sure what happened but all the data from yesterday got messed and I need to delete it.
I have the same question …
Back when the HA update around Jan. 31. rolled out I didn’t have any energy measurements for 3 days, because we had to change the configuration for the state_class to total_increasing … after I did that everything seemed to work again … well - now I took a look at the consumptions again and saw, that the monthly and yearly individual device consumptions show negative values!!! (like minus over 1000kWh for some devices)
This is only for February, the whole year and the week between 31. and 6., in which the measurements were not available for three days.
long story short, I would simply like to manually feed the database with somewhat accurate values for these days (like copy them from another day), so the yearly consumption is correct again
TiagoRoxo
February 21, 2022, 10:12am
4
The million dollar question is still the same: How to delete/edit a single day out of Energy History?
drthanwho
February 21, 2022, 10:49am
5
There’s an open PR for that functionality. Hopefully soon
home-assistant:dev ← home-assistant:adjust_statistics
opened 07:31PM - 28 Jan 22 UTC
<!--
You are amazing! Thanks for contributing to our project!
Please, DO N… OT DELETE ANY TEXT from this template! (unless instructed).
-->
## Proposed change
<!--
Describe the big picture of your changes here to communicate to the
maintainers why we should accept this pull request. If it fixes a bug
or resolves a feature request, be sure to link to that issue in the
additional information section.
-->
Add WS API `recorder/adjust_sum_statistics` which allows adjusting incorrect energy statistics.
The API accepts a statistic id (same as entity_id in most cases), a start time and an adjustment.
All statistics created at or later than the given start time is adjusted by the requested amount.
Note that no unit conversion is done; the adjustment must be in the unit used by the database:
- kWh for energy
- m³ for gas
Example to adjust sum statistics for sensor.total_energy up by 7MWh, starting at midnight new year's eve:
```json
{
"type": "recorder/adjust_sum_statistics",
"statistic_id": "sensor.total_energy",
"start_time": "2022-01-01 00:00:00Z",
"adjustment": 7000.0
}
```
## Type of change
<!--
What type of change does your PR introduce to Home Assistant?
NOTE: Please, check only 1! box!
If your PR requires multiple boxes to be checked, you'll most likely need to
split it into multiple PRs. This makes things easier and faster to code review.
-->
- [ ] Dependency upgrade
- [ ] Bugfix (non-breaking change which fixes an issue)
- [ ] New integration (thank you!)
- [ ] New feature (which adds functionality to an existing integration)
- [ ] Breaking change (fix/feature causing existing functionality to break)
- [ ] Code quality improvements to existing code or addition of tests
## Additional information
<!--
Details are important, and help maintainers processing your PR.
Please be sure to fill out additional details, if applicable.
-->
- This PR fixes or closes issue: fixes #
- This PR is related to issue:
- Link to documentation pull request:
## Checklist
<!--
Put an `x` in the boxes that apply. You can also fill these out after
creating the PR. If you're unsure about any of them, don't hesitate to ask.
We're here to help! This is simply a reminder of what we are going to look
for before merging your code.
-->
- [ ] The code change is tested and works locally.
- [ ] Local tests pass. **Your PR cannot be merged unless tests pass**
- [ ] There is no commented out code in this PR.
- [ ] I have followed the [development checklist][dev-checklist]
- [ ] The code has been formatted using Black (`black --fast homeassistant tests`)
- [ ] Tests have been added to verify that the new code works.
If user exposed functionality or configuration variables are added/changed:
- [ ] Documentation added/updated for [www.home-assistant.io][docs-repository]
If the code communicates with devices, web services, or third-party tools:
- [ ] The [manifest file][manifest-docs] has all fields filled out correctly.
Updated and included derived files by running: `python3 -m script.hassfest`.
- [ ] New or updated dependencies have been added to `requirements_all.txt`.
Updated by running `python3 -m script.gen_requirements_all`.
- [ ] For the updated dependencies - a link to the changelog, or at minimum a diff between library versions is added to the PR description.
- [ ] Untested files have been added to `.coveragerc`.
The integration reached or maintains the following [Integration Quality Scale][quality-scale]:
<!--
The Integration Quality Scale scores an integration on the code quality
and user experience. Each level of the quality scale consists of a list
of requirements. We highly recommend getting your integration scored!
-->
- [ ] No score or internal
- [ ] 🥈 Silver
- [ ] 🥇 Gold
- [ ] 🏆 Platinum
<!--
This project is very active and we have a high turnover of pull requests.
Unfortunately, the number of incoming pull requests is higher than what our
reviewers can review and merge so there is a long backlog of pull requests
waiting for review. You can help here!
By reviewing another pull request, you will help raise the code quality of
that pull request and the final review will be faster. This way the general
pace of pull request reviews will go up and your wait time will go down.
When picking a pull request to review, try to choose one that hasn't yet
been reviewed.
Thanks for helping out!
-->
To help with the load of incoming pull requests:
- [ ] I have reviewed two other [open pull requests][prs] in this repository.
[prs]: https://github.com/home-assistant/core/pulls?q=is%3Aopen+is%3Apr+-author%3A%40me+-draft%3Atrue+-label%3Awaiting-for-upstream+sort%3Acreated-desc+review%3Anone+-status%3Afailure
<!--
Thank you for contributing <3
Below, some useful links you could explore:
-->
[dev-checklist]: https://developers.home-assistant.io/docs/en/development_checklist.html
[manifest-docs]: https://developers.home-assistant.io/docs/en/creating_integration_manifest.html
[quality-scale]: https://developers.home-assistant.io/docs/en/next/integration_quality_scale_index.html
[docs-repository]: https://github.com/home-assistant/home-assistant.io
1 Like
TiagoRoxo
April 7, 2022, 8:28am
6
SOLVED =) In the latest HA build, we have now the Statistics in dev menu that allow us to fix the consumptions that were wrong. https://FQDN:8123/developer-tools/statistics
3 Likes
How painful is that if you want to delete a whole day!
4 Likes
F_Santolini
October 3, 2022, 5:19pm
8
Ciao! how can I delete it from the statistics? cannot find any way to do it
Santolini,
In the right look for one statistic that has the “adjust sum” and select the day and hour that is wrong in the energy dashboard and adjust the number to 0 or one similar off the last 10’.
If I want to use this method, I have to change 12x24=288 datapoints to zero PER day to remove that specific day. Is there another option?
2 Likes
I know how you feel. I just went thru the whole week of statistics to fix a couple of entities and right now all I can say is that statistics adjustment window is a torture.
not sure if it will leave a mark, but I guess we should pick a topic, wrote some needed features there and vote, vote, vote! I’ve found one with relatively high vote count [relatively to other statistics-themed requests] and typed some wishlist of mine
5 Likes
