Hi! I have an MySQL database collecting values from Digitemp temperatures. I have now incorporated values from my kWh-meter and taking pulses during every 5 minutes and put these into the rows with temperatures. As these data looks more like noise with spikes up and down I would like to average the last 16 rows but really don't how to do that.
Roughly how the rows look like:
------Date -----Time --Celsius --wh --------Kwh ---today
2016-10-23 |15:50 |10.69 |205.00 |208164 |12
wh are pending all between 120 to over 500 mostly between 150 and 200. The tall spikes are when the water heater goes on. But they last only for a few minutes if you don't shower a lot :-)
Can I put pictures, screendumps into here?
The address to my diagram:
http://tempuss.dynu.com
Hope for some tips..
Regards, Ralph in Sweden