Mysql Reports
Support,
I am trying to create a few individual monthly reports for my line manager. The reports I am trying to create are the following:
1. Monthly call volume
2. Top 10 requesters by monthly call volume
3. Monthly call status volume eg. onhold, closed...
4. Category monthly call volume
5. How many calls completed/closed by technician
6. List of requests open for more than 2 days
I would like to create a chart in Excel from the results, but I am a novice with Mysql queries. Could you please advise me on what mysql queries I should use to get the most accurate results.
Thank you.
I am trying to create a few individual monthly reports for my line manager. The reports I am trying to create are the following:
1. Monthly call volume
2. Top 10 requesters by monthly call volume
3. Monthly call status volume eg. onhold, closed...
4. Category monthly call volume
5. How many calls completed/closed by technician
6. List of requests open for more than 2 days
I would like to create a chart in Excel from the results, but I am a novice with Mysql queries. Could you please advise me on what mysql queries I should use to get the most accurate results.
Thank you.