Alteryx Designer Desktop Discussions

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

Datediff the value from first row of a column, to the second column second row?

josedlr00
8 - Asteroid

Hello, I have two columns, Start of Call Datetime and End of Call Datetime. I want to find the time from when the call ended to when the next call begins ( in seconds). The problem is they are on different rows. I have attached a picture that shows which columns I'm referring to and which cells I want to obtain the time difference from. I used arrows for the first three but want to do it for the entire columns.

2 REPLIES 2
Luke_C
17 - Castor

Hi @josedlr00 

 

You can use the DateTimeDiff() function in a multi-row formula tool:

Luke_C_0-1684803134914.png

 

josedlr00
8 - Asteroid

Thank you, this was exactly what I was looking for.

Labels