Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

I think I need a Mulitrow tool?

Bigmonki
8 - Asteroid

Hi, after some help with a challenge to identify concurrent logins! I think I need the multirow tool, but not sure if it is right and how to write the formula.

 

I have a login date, Time In and Time out. My challenge is to identify where on the same day, the same user has logged on after the initial Time in but before any previous Time out, in other words, where the user has logged in concurrently and times overlap.

 

In the attached data example Green indicates a logon date and time in that occurs after a previous date and time out, Yellow indicates where there is a time in before a previous time out marked in Red.

 

The data is sorted by Userid, date descending, time in ascending and time out ascending. 

 

I would be grateful for any assistance. 

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Hi @Bigmonki, I don't think you attached the correct file.

Bigmonki
8 - Asteroid

@DavidP Thanks, you are correct, the right one is now attached

UgoAgo
Alteryx Alumni (Retired)

Hello @Bigmonki ,

I have created a quick workflow to help.

 

UgoAgo_0-1597921674986.png

 

Labels