Overlapping Orders

[sdpeacock]

Alteryx users, I'm working on a project and need some help.

I looking at a set of order information in the format listed below. I am attempting to identify which customers had overlapping orders and how long those orders overlapped each other in days. For example, in the sample shown below, CUST32521 had 2 overlapping orders and they overlapped for 30 days,  

LOCATION	TRANSACTION	PROVIDER	CUSTOMER	ITEM	CATEGORY	TRX DATE	DAYS SUPPLY	END DATE
A1	TRX84983	PROV1234	CUST32521	ITEM-1	A	3/5/2019	30	4/3/2019
A1	TRX33595	PROV1234	CUST32521	ITEM-2	A	3/5/2019	30	4/3/2019
A2	TRX54781	PROV1234	CUST23689	ITEM-3	B	1/26/2020	30	2/24/2020
A3	TRX92743	PROV1234	CUST48348	ITEM-3	B	9/13/2018	18	9/30/2018
A3	TRX17646	PROV1234	CUST48348	ITEM-3	B	10/2/2018	30	10/31/2018
A3	TRX49808	PROV1234	CUST48348	ITEM-3	B	11/6/2018	30	12/5/2018
A3	TRX57609	PROV1234	CUST48348	ITEM-3	B	1/9/2019	15	1/23/2019
A4	TRX96757	PROV1234	CUST19930	ITEM-2	A	1/7/2019	25	1/31/2019
A4	TRX91752	PROV1234	CUST19930	ITEM-2	A	8/7/2019	30	9/5/2019
A4	TRX46044	PROV1234	CUST19930	ITEM-2	A	9/7/2019	30	10/6/2019

I've attached a larger data set with more variance for testing and proof of concept. I appreciate any assistance you can offer. 

Thank you!!

[Aaron_Harter · Accepted solution]

Hi @sdpeacock,

I've designed some logic to identify customers with multiple transactions running on overlapping days: 

 

[sdpeacock]

Thank you very much @Aaron_Harter !