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