[thelist] Understanding an SQL Problem

[Rob Smith]

Rudy

Now that I've collected all this neat data (When Users log in to my
Intranet), I want to display it graphically. I want to visualize the times
people access by hour of the day. Example:

(hours isolated)

6
6
6
7
7
7
7
7
8
8
8
8
8
8
....
15
15
15
16
16

Now, count the 6's, 7's, and on. Find the max number of times in a single
hour our Intranet was accessed. Set that to "100%". Now, in a neat little
table:
<table>
  <tr>
     <!-- in a loop -->
     <td>
        <%=count_per_hour(count)%>
     </td>
     <!-- end a loop -->
  </tr>
  <tr>
    <!-- in a loop -->
     <td>
        <img src="greybox.gif" width="5"
height="<%=percent_of_total(count)%>">
     </td>
    <!-- end a loop -->
  </tr>
</table>

I should see something like this:

     1     1 2 3 6 6 5  1  5  4 3 2 2 1

                 X X
                 X X X     X
                 X X X     X  X
               X X X X     X  X X
             X X X X X     X  X X X X
     X     X X X X X X  X  X  X X X X X
12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12
            AM                     PM

Just another attempt at me doing statistics,

Rob.Smith