Repeat Callers in 3 days & 7 days

A_M — Mon, 11 Sep 2023 10:32:21 GMT

Hi ,

I need to calculate the repeat callers who have called within 3 days of their first call as shown below.

A person will be considered for that date if he calls on that particular date only.

Similiarly for 7 days.

Re: Repeat Callers in 3 days & 7 days

edwin — Wed, 13 Sep 2023 13:28:08 GMT

try this:

data: load * inline [ customer, callDate A, 1/1/2023 A, 1/3/2023 A, 1/4/2023 A, 1/5/2023 A, 1/9/2023 B, 2/1/2023 B, 2/7/2023 B, 2/9/2023 ]; NoConcatenate tmp: load distinct * Resident data; inner join (tmp) load customer, callDate as repeatCallDate Resident tmp; NoConcatenate repeatCalls: load * Resident tmp where repeatCallDate > callDate and repeatCallDate <= callDate+3; NoConcatenate hasRepeatCalls: load distinct customer, callDate, 'yes' as hasrepeatCalls Resident repeatCalls; left join (data) load * Resident hasRepeatCalls; drop table tmp, repeatCalls, hasRepeatCalls;

repeatCalls table holds all repeat dates that qualify as repeat calls. you can expand on this to implement the totals by just aggregating it. from the sample data:

topic Re: Repeat Callers in 3 days & 7 days in App Development

Repeat Callers in 3 days & 7 days

Re: Repeat Callers in 3 days & 7 days