Alteryx Designer Desktop Discussions

jbuszin · ‎03-31-2020

I have two different date fields that represent ID 1 talking to two different people. I'm interested in creating a 0/1 indicator of if more than 30 days pass between calls to person A, how many calls were made to person B in the 30 days prior to the next call to person A. For example, there are 128 days between 4/23 and 8/29. So in that case, I want to know the total number of times ID 1 talked to person B, but only the calls with person B that happened within 30 days of 8/29. So although 13 total calls happened only 11 of them should count. Imagine a third column on the right where the first row is null, the second is 0, the third is 0, but the fourth (and subsequent rows until the 8/29 row for talked to person A) is 1.

And because the next call to Person A happened just 12 days later, I would count the person B call as a 1 in this third column we're creating. Finally, a call to person A doesn't happen again for 85 days, until 12/4. So I'm wanting to put a "1" next to each of the calls to person B that happened between 11/4-12/4 only. The calls from 9/20-11/3 don't count and get a 0. Hope that makes sense.

Talked to Person A	Talked to Person B
4/23/2018	[Null]
[Null]	6/13/2018
[Null]	7/18/2018
[Null]	8/6/2018
[Null]	8/8/2018
[Null]	8/9/2018
[Null]	8/10/2018
[Null]	8/13/2018
[Null]	8/21/2018
[Null]	8/23/2018
[Null]	8/24/2018
[Null]	8/27/2018
[Null]	8/28/2018
[Null]	8/29/2018
8/29/2018	[Null]
[Null]	9/10/2018
9/10/2018	[Null]
[Null]	9/20/2018
[Null]	9/21/2018
[Null]	9/24/2018
[Null]	10/3/2018
[Null]	10/8/2018
[Null]	10/10/2018
[Null]	10/12/2018
[Null]	10/18/2018
[Null]	10/23/2018
[Null]	10/24/2018
[Null]	10/25/2018
[Null]	10/26/2018
[Null]	10/28/2018
[Null]	10/29/2018
[Null]	11/6/2018
[Null]	11/7/2018
[Null]	11/8/2018
[Null]	11/9/2018
[Null]	11/19/2018
[Null]	11/20/2018
[Null]	11/21/2018
[Null]	11/28/2018
[Null]	11/29/2018
[Null]	11/30/2018
[Null]	12/3/2018
12/4/2018	[Null]