Darren New wrote:
> 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.

Care to write an SQL statement? ;-)

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message