Hi Alteryx Community, I'm trying to sort out a way to identify and group users who logged in to the same computer terminal on the same day within a given window of time. For example: Which User IDs logged in to the same terminal on the same day within one hour of each other? I've attached some sample data as a reference. Ideally I would like to be able to tweak the date/times ranges for different applications. Thanks very much! Log_On_DateLog_On_TimeTerminalUser_ID3/13/201711:42:4312351555555544/17/201722:40:1112361666666654/19/201710:13:1512371777777764/20/20179:50:0312381888888876/3/201715:31:0212391999999986/4/20173:17:0312402222222206/4/20174:00:0012402333333316/4/20174:14:0312402111111092/21/20189:20:2790004999999953/22/201812:32:1790015111111064/23/20184:48:0690025222222175/14/20184:54:1690035333333285/15/20189:51:059004544444439 Sample_Data.xlsx

Group Users by Same Terminal, Window of Time

Hi Alteryx Community,

I'm trying to sort out a way to identify and group users who logged in to the same computer terminal on the same day within a given window of time.

For example: Which User IDs logged in to the same terminal on the same day within one hour of each other? I've attached some sample data as a reference. Ideally I would like to be able to tweak the date/times ranges for different applications.

Thanks very much!

Log_On_Date	Log_On_Time	Terminal	User_ID
3/13/2017	11:42:43	1235	155555554
4/17/2017	22:40:11	1236	166666665
4/19/2017	10:13:15	1237	177777776
4/20/2017	9:50:03	1238	188888887
6/3/2017	15:31:02	1239	199999998
6/4/2017	3:17:03	1240	222222220
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109
2/21/2018	9:20:27	9000	499999995
3/22/2018	12:32:17	9001	511111106
4/23/2018	4:48:06	9002	522222217
5/14/2018	4:54:16	9003	533333328
5/15/2018	9:51:05	9004	544444439

Sample_Data.xlsx

Date Time

Common Use Cases

Best Practices

Accepted answers

ponraj

Here is the sample workflow for you case. Hope this is helpful.

Workflow Results Results

Group Users by Same Terminal, Window of Time.yxmd

All comments

ponraj

It would be great you could share the sample result you are looking for...

CMH

Hi Ponraj,

Thank you for your help. In the sample data (Example A) there two users active on the same terminal within an hour on the same date (6/4/2017). As a result, I'm hoping the final output would be something like this (see Example B below).

Example A: Sample Data

Log_On_Date	Log_On_Time	Terminal	User_ID
3/13/2017	11:42:43	1235	155555554
4/17/2017	22:40:11	1236	166666665
4/19/2017	10:13:15	1237	177777776
4/20/2017	9:50:03	1238	188888887
6/3/2017	15:31:02	1239	199999998
6/4/2017	3:17:03	1240	222222220
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109
2/21/2018	9:20:27	9000	499999995
3/22/2018	12:32:17	9001	511111106
4/23/2018	4:48:06	9002	522222217
5/14/2018	4:54:16	9003	533333328
5/15/2018	9:51:05	9004	544444439

Example B: Output

Log_On_Date	Log_On_Time	Terminal	User_ID
6/4/2017	4:00:00	1240	233333331
6/4/2017	4:14:03	1240	211111109

ponraj

Here is the sample workflow for you case. Hope this is helpful.

Workflow Results Results

Group Users by Same Terminal, Window of Time.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703