I have a table that is full of records of individual inquiries. It is basically like a ticketing CMS for a call center. The table can have two inbound contacts from an inquirer, and then one outbound contact from us, etc. Each record also indicates the ID of the inquirer (related to the primary key of another table of people)
What I want to do is make a report that will show the average number of days between the first inbound contact to the first response by us.
The report will list the name of the person and the average time. If they inquire multiple times, and there are multiple responses, those should also be averaged.
Any thoughts on the best way to go about this?