I am counting the number of customer returns. For example if a customer goes from Dept A to Dept B then Dept B back to Dept A, it is only considered as a single return if they do this. I have it counting the route, but it is counting twice. In the month they completed A to B
and B to A, so if they went from A to B in Jan, and B to A in Feb, it is counting 1 in Jan and 1 in Feb, it should only begin counting all events after the B to A portion is completed. so in Feb the solution should be 1 return.
Thanks, I don't have an application to share but I will write this out the best way I can.
I have a list of customers
Customer A
Customer B
Customer C
Customer D
First Department
a
b
c
d
Next Department
e
f
g
h
path I am counting when customer goes from a to e and e back to a is a single return
Thanks
What I've done is is counting the first instance of the first time the customer went from a to e
and the last instance the customer went from e to a, and counted the times and divided by to, but my issue is what happens when the go from a to e in on month and e to a in another month, I only want it to count all events in the month of the completion of e to a.
