Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Days between Orders

SCOTTJSCOTT
5 - Atom

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.

 

 Alteryx.png

 

Thanks

 

Mark

2 REPLIES 2
LordNeilLord
15 - Aurora

Hi @SCOTTJSCOTT,

 

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

 

Something like this

 

Datediff.PNG

SCOTTJSCOTT
5 - Atom

Perfect thank you. Appreciate the quick response.

Labels