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

Dates within interval date

Badrelouizi
6 - Meteoroid

Hi everyone,

 

I want to know if there is a way to test if all the calls (1 to 4) are within the start/end interval date. Please advise

I tried to do it cal by call but that's not efficient and created a lot of formulas.

 

USER_IDDISCH_NOTIFY_DATEDISCH_START_INTERVALDISCH_END_INTERVALDistance_Dayscall #1call #2call #3call #4Contact_Flag_1Contact_Flag_2Contact_Flag_3Contact_Flag_4
10162/4/2020 0:002/4/2020 0:003/5/2020 0:00302/4/20202/5/20202/7/2020 MEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER REACHED 
10164/30/2020 0:004/30/2020 0:005/30/2020 0:00305/1/20205/1/20205/5/20205/8/2020MEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHED
10164/21/2020 0:004/21/2020 0:005/21/2020 0:00304/22/20204/27/2020  MEMBER NOT REACHEDMEMBER REACHED  
10163/6/2020 0:003/6/2020 0:004/5/2020 0:00303/6/20203/10/20203/12/20203/17/2020MEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER REACHED
10161/30/2020 0:001/30/2020 0:002/29/2020 0:00301/13/20201/17/20201/20/20201/23/2020MEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHED
10164/3/2020 0:004/3/2020 0:005/3/2020 0:00304/6/20204/9/20204/13/20204/13/2020MEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHEDMEMBER NOT REACHED
5 REPLIES 5
RobertOdera
13 - Pulsar

Hi, @Badrelouizi 

 

Try this.

Please mark as acceptable solution + like, if it works for you.

 

RobertOdera_0-1592611241047.png

 

The workflow is attached.

Cheers!

Blake
12 - Quasar

Hi @Badrelouizi 

 

I created a workflow that summarizes whether all the calls were in the window or not. I made an assumption that it is ok to have less than 4 calls and that it is ok for the first and last calls to be on the start/end dates. 

 

badrelouizi.png

RobertOdera
13 - Pulsar

Really cool, @Blake !

 

So, @Badrelouizi  you have, hopefully, all angles covered?

 

One solution assesses whether each call was in interval.

Other solution assesses whether all calls were in interval.

 

Cheers!

Badrelouizi
6 - Meteoroid

Thank you guys. This is very helpful!

RobertOdera
13 - Pulsar

You're most welcome @Badrelouizi !

Cheers.

Labels