MySQL Forums
Forum List  »  Newbie

Average 16 rows back?
Posted by: Ralph Höglund
Date: October 23, 2016 08:09AM

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

Options: ReplyQuote


Subject
Written By
Posted
Average 16 rows back?
October 23, 2016 08:09AM
October 23, 2016 09:10AM
October 23, 2016 09:46AM
October 24, 2016 02:57AM
October 24, 2016 10:30AM
October 25, 2016 02:30AM
October 25, 2016 06:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.