in reply to Re: Re: Data structure advice
in thread Data structure advice

Hmm. How do you arrive at 48 values per day? The snippet you showed has 3 values per hour, which for 24 hour days is 72 values per day :-)

Replies are listed 'Best First'.
Re: Re: Re: Re: Data structure advice
by robinbowes (Beadle) on Jan 05, 2004 at 15:33 UTC
    Doh! There is a logical explanation for this...

    The data was extracted from the production system, following data processing. The raw data is generated every 30 mins at 20 and 50 mins past the hour. The values on the hour are averages calculated from the previous and following values.

    R.

    --

    Robin Bowes | http://robinbowes.com