Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
view community events calendar
designer new user guide
Labels