Monkeyboy126
IS-IT--Management
I run a helpdesk and use CA's USD call logging software sitting on SQL.
I want to calculate the backlog (calls that were in an open state for selected date or day by day for a date range). The database has the following fields:
Datetime opened
Datetime Closed
Active flag (1 or 0)
I am looking to chart the outstanding calls on a day by day basis for a given period.
Any ideas???
I want to calculate the backlog (calls that were in an open state for selected date or day by day for a date range). The database has the following fields:
Datetime opened
Datetime Closed
Active flag (1 or 0)
I am looking to chart the outstanding calls on a day by day basis for a given period.
Any ideas???