Each contact (client) will have appointment that get assign to one of the user (staff).
Every time the appointment finish, we put the "Result" to records whats the result from the appointment.
Able to have a report for how many appointment that particular user seen with the result
AGENT NAME ISSUED SEEN DNQ COMMENT
Joe 10 9 3 asdfb
ISSUED -> Number of appointment that assign to him
SEEN -> Number of appointment that he actually see, because sometimes client cancel last minute
DNQ - > Number of appointment's result that client that is not qualified
First step that I am stuck with is that pull up a query or filter for Activities that has been completed.
I cannot figure it out what table I should call.
Once I know what table that saved all the Activities List that has been completed, I can make a "Count to produce the number of the "Issued" or "Seen"
If anyone know how can I get the list of activities that has been completed for all contact that would be great!Thank you!!