in reply to Grouping by week

Since you have the dates in localtime list format, you can choose among POSIX::strftime()'s %U, %V, and %W formats to get the week for each date. Using the week number as an index into an array, increment the array element for each 'PASSED' flag you see. To get averages, you'll need to keep track of the total number of entries for a week, too.

After Compline,
Zaxo

Replies are listed 'Best First'.
Re: Re: Grouping by week
by ear (Acolyte) on Sep 19, 2003 at 16:09 UTC
    This helped a lot. I haven't messed with the POSIX stuff much at all and this is the second time now that it has gotten me through a problem. Guess I really need to do some reading. I now am able to break down my data and display it like this using your advice which is exactly the way I needed it. N/A represents a week where I didn't have 5 days of data. Thanks MUCH.
    27      N/A
    28      60
    29      60
    30      100
    31      100
    32      40
    33      100
    34      80
    35      100
    36      60