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

Adding a Timeline

Gaetano_B
8 - Asteroid

Hi Wonderful People,

 

Could you kindly help me create columns E&F of the attached.

 

Col. E contains three milestones Completion, QC Submission and Business Connection.

Col. F shows an overview of the milestone status, which is based on the dates shown in col. B&C and D and indicates whether the milestone is overdue, due next 7 days etc.. with a view up to 45 days.

 

I know It's  quite a complex task, would someone be so kind to help?

 

Thanks in Advance,

Gaetano

 

 

2 REPLIES 2
OllieClarke
15 - Aurora
15 - Aurora

Hey @Gaetano_B I had a crack at this, but my answers are a bit different to yours

for instance this record only has 1 row in your dataset,

OllieClarke_0-1602865257560.png

whereas my output looks like this:

OllieClarke_1-1602865341901.png

Is there some other logic at work rather than just filtering out those milestones which are more than 45 days away (in either direction?)

 

I've attached my workflow so you can have a look anyways though.

 

OllieClarke_2-1602865447931.png

 

 

 

Gaetano_B
8 - Asteroid

That looks great. Much appreciated, thanks @OllieClarke 

Labels