I had another question before about moving averages via sql statement and the response I got was great.
Now I'm trying to "sample" the data. I guess it would be a form of smoothing but I'm not sure what to call it. I want to do something like this: row1 = (item[0] + item[1] + item[2] + item[3] )/4) row2 = (item[4] + item[5] + item[6] + item[7] )/4) row3 = (item[8] + item[9] + item[10] + item[11] )/4) I'm using some pseudo code here, I hope this make sense. Example Table: tableID Minute Watt I'm trying to sum average the watt column by minute. Thanks in advance. -- View this message in context: http://old.nabble.com/Sampling-Data-tp26597669p26597669.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
