I am tyring to find the best way to group customer sessions together by their time stamp.
I want to do something like, if Customer_Link = Customer_Link and Log-Time is within 30 min then same session if > 30 min then new session. Here is a little screen shot of the data. Let me know what you guys think would be best. Think I am over thinking this.
ew session. Here is a little screen shot of the data.
Solved! Go to Solution.
The easiest way to do this is using a Multi-Row formula that groups by Customer_Link so it increments the session number up one if the log time is outside of the 30 minute range as you can see in record 5 below. Workflow is attached for reference. Make sure that the Log-Time is in an actual date time format and that it is sorted in ascending order for this to work properly.