community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎06-19-2020 02:05 PM

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
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

5 REPLIES 5
RobertOdera
13 - Pulsar
‎06-19-2020 05:02 PM

Hi, @Badrelouizi 

 

Try this.

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

 

RobertOdera_0-1592611241047.png

 

The workflow is attached.

Cheers!

For_Badrelouizi.yxmd
Reply
Blake
12 - Quasar
‎06-19-2020 05:10 PM

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

badrelouizi.yxmd
Reply
RobertOdera
13 - Pulsar
‎06-19-2020 07:11 PM

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!

Reply
0 Likes
Badrelouizi
6 - Meteoroid
‎06-22-2020 11:19 AM

Thank you guys. This is very helpful!

Reply
RobertOdera
13 - Pulsar
‎06-26-2020 12:03 PM

You're most welcome @Badrelouizi !

Cheers.

Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels