Ok, as Tim Bray does, I am here to expose the stupid with the great in all the code I write.

Mine was even more brain-damaged. I generate a series of aggregate Web Log stats,after filtering out bots/crawlers/images/css/robots.txt/etc., to generate meaningful information on the visitors to my sites.

However, the aggregate stats were not meshing with the drilldowns I was generating to examine data views, such as who hit what pages, who hit during what hour, etc.

Well, it helps if you look at the same data. The drilldowns used the following SQL filter:

ap.bytes != 0

Ummm…if I built the TEMP table for aggregate data view page using the same filter, the information would be aligned.

A Homer Moment…DOH!