Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Grouping Customers sessions

kevin91
6 - Meteoroid

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. 

 

 

kevin91_0-1596673062582.png

 

ew session. Here is a little screen shot of the data. 

1 REPLY 1
BrandonB
Alteryx
Alteryx

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. 

 

solution.png

Labels