Database - Double Value help

Hey all,

I have an Aeotec Gen 5 Energy Meter. Once a month over the last three months I have had one day with an outrageous value in the energy dashboard. It shows 100,000 + kWhr of usage. This causes all of the calculations and graphs to be way off. I have been looking at how to manipulate the data using SQLite. I was assuming I could just delete one value and I would be ok for each month. After exporting the table of the Energy Monitor; it looks like it is not just one value that I will need to change to make this work. Seems to be a weird doubling up that is happening. Below is what looks to be happening. The time interval is not the same between each month it does this. Any ideas on what I am missing on how to fix this? I am a bit stumped.

​

31606	2021-12-11 2:00:10	4	2021-12-11 1:00:00	46680.91	48664.08
31627	2021-12-11 3:00:10	4	2021-12-11 2:00:00	46683.3	48666.47
31648	2021-12-11 4:00:10	4	2021-12-11 3:00:00	46685.64	95352.81