troubleshooting Question

Average Time Calculation

Avatar of sfareed
sfareedFlag for United States of America asked on
Microsoft SharePoint
3 Comments1 Solution400 ViewsLast Modified:
I created a lightweight helpdesk application on  SharePoint 2007.
In this application I used Issue tracking list.
1) User create a ticket
2) The manager receive an email and he assign the ticket to the technician
3)The technician resolve the issue and change the status of the ticket “Completed”.
I need to calculate the average time of the tickets from “created time “ to “completed” time.
Like I want to display on the “Reporting” section that
In 24 hours we resolve 3 tickets
Or the average ticket time to resolve the issue was 17 Hours  
Any idea how to accomplish this task.
Following is a formula I am working on:
Created at 1/23/2012 10:0 AM
Last modified at 1/25/2012 10:00 AM
Status =Complete
 Ticket Completed Time for One Ticket= Ticket Completed Time(by Technician) – Ticket Created Time(by user)
            example=(1/25/2012 at 10.00 )      -   (1/23/2012 at 10.00 )
            Answer=48 Hours
Average Ticket Time to complete for all tickets= Ticket Completed Time for All Tickets/ Total Number of Tickets.
            Example= (48 +32+56+78+96+72)/6
                  = 310/6
Average Ticket time = 51.66 Hours
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros