topic Re: Minutes between records in Alteryx Designer Desktop Discussions

Minutes between records

Watermark — Mon, 15 Jul 2019 21:30:03 GMT

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.

Re: Minutes between records

Thableaus — Mon, 15 Jul 2019 21:44:48 GMT

Hi @Watermark

You're probably checking the Group By box.

Uncheck it and it might work.

Otherwise please pump us some data.

Cheers,

Re: Minutes between records

Watermark — Mon, 15 Jul 2019 21:48:17 GMT

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