We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
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
Top Solution Authors