in reply to Re: Data averages by time of day
in thread Data averages by time of day

Something along those lines was one of the ideas I was playing around with but with finer blocks of time.

select hg from readings where time > "04:00" and time < "4:30"; . . . and so on
and then averaging the time slots. Where I have no values in a given time slot I could to linear interpolation. Abigail makes a very valid point that I am trying to wrap my head around to figure out how to implement it is the theory (fact?) that there may be a sinusoidal relationship to consider as well.

I beginning to think that I have a good basis for a posting to CUFP when I get this working.

Peter L. Berghold -- Unix Professional
Peter at Berghold dot Net
   Dog trainer, dog agility exhibitor, brewer of fine Belgian style ales. Happiness is a warm, tired, contented dog curled up at your side and a good Belgian ale in your chalice.