We have a telephone system that records call information into a mysql database. I need this information to be analyzed so we can spot trends etc. I would like to be able to display and print line graphs of calls taken and calls lost etc between two dates. Also be able to break down which how many each extension takes (theres only 3 extensions). I would also like reports automatically produced and emailed.
1) The shift reports that needs to be sent automatically following a schedule (which we can edit)
The email reports would need to give the details in text
Date- From Time To Time
Total calls: 100 Total lost: 51
Ext 225: 50
Ext 227: 25
Ext 228: 25
then it would need a line graph displaying the same information embedded in the email.
I don't want a PDF, it's needs to be displayed so the person receiving it can't ignore it because they can't be bothered to open another program.
I also want a trigger to put a warning in the subject field when missed calls exceed a certain amount
(we need this amount to editable as an option)
2) The weekly report needs to sent out just in graph form which we will print out and store.
This will need to go to a different email address.
3) We then need a facilty to create a report at will.
We need to have the following choices.
By date range, including/excluding extension, including/excluding queues, answer/unanswered calls.
Outputting results by text / graphs /both.
Hope this helps you get a better idea of what we are after.
34 pekerja bebas membida secara purata $436 untuk pekerjaan ini
Hello Sir/Madam, I work as a data typish in a big company for a few years. I know for sure to finish this kind of job correctly and fast. Please contact/email me. Thank you. Gthijs