ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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