I am trying to recreate user sessions from our IIS logs. I have everything processed down to the users, datetime, and what pages they visited.
What I'm trying to do is.....
for a given user I want all pages hit within a given time, say 45 min. or an hour. I guess an hour would be easier for this discussion.
so right now, my data looks like this...
name, timestamp, page1, page2, page2, page 4
bob 1:01 0 1 0 0
bob 1:04 1 0 0 0
bob 1:05 0 0 1 0
if bob visited all these pages within the hour then I want the table to look like.....
name, page1, page2, page2, page 4
bob 1 1 1 0
I don't really see how to combine this together. Any help would be appreciated.