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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels