Could you provide some example data? I'm particularly interested in the values of the Minute field. -R.
npearson99 wrote: > 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. > > > -- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA Genealogy, et Cetera: http://freepages.rootsweb.ancestry.com/~dav4is/ 538 ancestral & collateral families, mostly 17°-19° century New England & European roots. Total population: 136,000+ Annex: http://www.gencircles.com/users/dav4is/ email: [email protected] A Democrat, a Republican and a giraffe walk into a bar. The bartender looks up from his want ads and says, "What is this, a joke?" -unknown _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
