MySQL Query for Spread/Difference of Energy Counter and missing Value interpolation
I have an energy counter (kWh) recorded in a MySQL database every 15 minutes. Sometimes the recording fails for several reasons (power outage, computer reboot for updates...) and values are missing. The table looks as followed: id Time Energy 27800…