| |||||||||||
 |
 |
| | LinkBack | Thread Tools | Search this Thread | Rating:  | Display Modes |
(#1)
  |
| New Member Posts: 4 Join Date: Nov 2006 | SQL Query to calculate Average Staff Response time -
08-04-2009, 12:25 PM
I am fairly proficient in SQL, so if someone could get me started, I could probably work out the details, but here is what I am looking for: On the front of vbulletin.com, there is a box in the left hand sidebar that says: Average Response Time (last 30 support issues) 0 hr : 25 min then they put their disclaimer. I'd like to be able to generate something like this from my eSupport database. Can someone get me started? What tables to look at? What columns? How to decode an encoded php datetime field? Thanks for any assistance! -Joe PS. If it matters, I am currently on 3.20.02 but will be upgrading to 3.50 within a week or two. |
| |  |
|
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Average Response Time Module | crux | Requests | 3 | 07-06-2009 11:10 AM |
| Calculating Average Support Time | -Dan | Developers & Code | 2 | 18-08-2007 10:11 PM |
| Average response time for a department | JamesSmith | SupportSuite, eSupport and LiveResponse | 0 | 18-02-2007 04:14 PM |
| Feature Request: Reports - Summary Average Response Time | chelsel | LiveResponse Desktop Application | 0 | 13-02-2007 08:04 PM |
| SQL query to show response time in minutes | jamesM | Developers & Code | 0 | 22-09-2006 11:04 PM |
Linear Mode
