I have a problem and I'm not sure of the best solution so I'm hoping someone can give me a steer.
I need to provide some repeat caller analysis for a call centre. I have a table containing every call presented to the centre, it contains among other things:
[Calling Line Identity] varchar(11) - the callers telephone number
[Date and Time] datetime - of the call
[Number dialled] varchar(11) - the number the caller dialled to get to the call centre
I need to produce some output that looks like this:
Date, One, Two, Three, Four, Five, More than Five
09/01/2008, 12365, 476, 242, 130, 67, 18
09/02/2088, 10250, 452, 220, 101, 35, 25
It needs to show, for each day, how many times callers that called on that day have called in the previous 7-days.
I would be grateful if someone could post a possible solution or point me the direction of any resources that explain the principles.
Many thanks in advance.