DateTimeDiff > x always the same result

Hi,

i have a problem with this formular:

when the difference between current timestamp and next timestamp is bigger then 15 minutes it should be flaged with "1"

where is my mistake?

Accepted answers

Hey @df

Swap the order of your fields

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

I was going another direction:

IF DateTimeDiff([Row+1:Timestamp],[Timestamp],"Minutes") > 15
THEN 1
ELSE 0
ENDIF

swap the variables.

Cheers,

Mark

Hey @df

Swap the order of your fields

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

I was going another direction:

IF DateTimeDiff([Row+1:Timestamp],[Timestamp],"Minutes") > 15
THEN 1
ELSE 0
ENDIF

swap the variables.

Cheers,

Mark

I actual change my mind...but still got it correct!

Oh well, you have answers for any way you want to do it

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover