Set Analysis

[detmawin]

Good day,

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.

Thank you.

[Anonymous]

Can you please share the sample data

[detmawin]

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.

so if they went fro a to e in jan

and e to a in feb I want it to count 1 in feb

thanks

[detmawin · Accepted solution]

this has been resolved.  I just shifted the calendar date.