The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Minutes between records

Watermark
12 - Quasar
12 - Quasar

 

 

Using multi-row, shouldn't the following give the number of minutes between records?   (column with datetime is named DateTime - just to state the obvious)

 

DateTimeDiff([Row-1: DateTime],[ DateTime],'minutes')

 

I just get a null or a zero (if it's the same time)  I don't get the minutes between the records. 

 

 

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Watermark 

 

You're probably checking the Group By box.

 

Uncheck it and it might work.

 

Otherwise please pump us some data.

 

Cheers,

Watermark
12 - Quasar
12 - Quasar

Yep, group by, got rid of it, and getting result I expected

Labels
Top Solution Authors