Darren New wrote:
> I would first find the duration of each page view, then look for page 
> views more than 10 minutes apart.

Or, to clarify. Count the number of sessions that *ended*.  Much easier 
than counting the number of sessions that started.  Finding the end of a 
session is finding the row where there's no row with a greater timestamp 
but within 10 minutes of this timestamp.

-- 
   Darren New / San Diego, CA, USA (PST)
     "That's pretty. Where's that?"
          "It's the Age of Channelwood."
     "We should go there on vacation some time."

Post a reply to this message