SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
I need to read a file of account records to determine when the same agent created a record for the same client within 10 minutes. Ultimately, I need to determine which agents are doing this and which are not. They should all be creating multiple records for the same patient sometimes while on the same call at the same rate. I just don't know if this is true for 1% of our calls or 20%, or which agents are doing this at 3% of their daily tickets and which are doing it at 0% or 30%.
Columns:
A = Date and time (EX: 04/12/2021 07:30)
B = Client ID of 2 letter and 6 numbers (EX: AB123456)
D = Agent ID of 2 letter and 6 numbers (EX: YZ123456)
In a typical day's file of 8,000 or so records, there could be dozens or hunderds of valid instances of an agent creating a record for someone and then creating another record for the same patient while they're still on the same call. There could even be 3 or more records created on the same call. A flag on each record like this or the % of each agent's total tickets that are these kinds of duplicates would answer my question.
There could also be cases of a second (or third, etc...) records created by different agents within 10 minutes - I'm not interested in those - If the agent is different that means there was a second call.
Anyway, to me this is one of those "if a train headed west at 78 MPH leaves New York at 6PM and a train headed east......" problems. I just can't do it.
Columns:
A = Date and time (EX: 04/12/2021 07:30)
B = Client ID of 2 letter and 6 numbers (EX: AB123456)
D = Agent ID of 2 letter and 6 numbers (EX: YZ123456)
In a typical day's file of 8,000 or so records, there could be dozens or hunderds of valid instances of an agent creating a record for someone and then creating another record for the same patient while they're still on the same call. There could even be 3 or more records created on the same call. A flag on each record like this or the % of each agent's total tickets that are these kinds of duplicates would answer my question.
There could also be cases of a second (or third, etc...) records created by different agents within 10 minutes - I'm not interested in those - If the agent is different that means there was a second call.
Anyway, to me this is one of those "if a train headed west at 78 MPH leaves New York at 6PM and a train headed east......" problems. I just can't do it.