Daily Archives: October 26, 2014

Breaking timeseries data into sessions

Edit: Since writing this I've found lots of ways to simplify this solution, for instance making use of the lag function in MS SQL, or MySQL solutions using variables, but I'll leave this here anyway! Problem: You have a lot of data about users interacting with your site, with a UserID and timestamp for each transaction. [...]