I need to create a report to display the following info, on a weekly basis:
1] Number of open calls at the start of the week 2] Number of new calls logged during the week 3] Number of calls closed during the week 4] Number of calls still open at the end of the week
I've tried to modify the existing "Report on Problems by Status" report, however I cannot find a field that will give me the total number of open calls at the start of the week etc. Has anyone else attempted creating the same/similar report and how did you go about doing it?
Any suggestions to accomplish the above would be appreciated.