Days between Orders

[SCOTTJSCOTT]

Hi All,

I am sure I cracked this one before but no luck this time.

How can I use Alteryx to determine the days between Orders for my customers while keeping all the other information. So need to create a field something like.

Days since Last Order (So for record 96 it would be 22)

Any sugestions.

 

Thanks

Mark

[LordNeilLord · Accepted solution]

Hi @SCOTTJSCOTT,

I'd go for the multi-row formula using DateTimeDiff()

Something like this

[SCOTTJSCOTT]

Perfect thank you. Appreciate the quick response.