Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
i have a scenario where i have 10k record dump
TicketNum | Users | Automation | Resolution time | RespnseTime |
---|---|---|---|---|
1 | abc | yes | 7/24/2015 12:29:20 PM | ,4/18/2012 8:15:08 AM |
2 | sas | yes | 6/17/2015 4:13:47 PM, | 8/27/2013 1:21:38 PM |
3 | cdh | yes | 5/26/2015 4:45:31 PM | 11/21/2013 7:28:58 AM |
4 | dfv | no | 6/25/2015 11:51:37 PM | 3/11/2014 2:04:02 PM |
here i have to calculate the number of efforts reducible in hours based on automation yes
also i have to calculate no of engineers that can be reducable overall based on automation yes., if the engineer is working 9 hours/day on average.
thanks in advance
Hi,
Would it be possible to get a little more information. I am not sure what you are trying to achieve with the given data.
For example - Is you first point the difference between RespnseTime and Resolution Time where automation = yes?
Mark
metrics for No. Of Efforts/Engineers?
Response time and Resolution time not related to automation . Automation is related to Description of the ticket id.
Exact sample is shown belw
ID | Description | Automation | Resolutiontime | Engineers | Response time |
1 | Lotus notes error | yes | 12/31/2012 8:07:33 AM | abc | 12/31/2012 7:09:31 AM |
2 | outlook error | yes | 12/31/2012 8:12:55 AM | axz | 12/31/2012 8:04:40 AM |
3 | unable to access website | yes | 12/31/2012 8:29:21 AM | asd | 12/31/2012 8:07:11 AM |
4 | CPU utilization failed | no | 12/31/2012 8:35:42 AM | fds | 12/31/2012 8:12:35 AM |
5 | unable to access printer | yes | 12/31/2012 8:58:50 AM | cdfg | 12/31/2012 8:15:27 AM |
6 | adobe reader issue | yes | 12/31/2012 9:18:50 AM | asdfg | 12/31/2012 8:18:36 AM |
7 | disk space issue | yes | 12/31/2012 9:25:04 AM | qwe | 12/31/2012 8:28:43 AM |
8 | problem with application or software | no | 12/31/2012 10:08:09 AM | axv | 12/31/2012 8:32:54 AM |
9 | hard disk problem | no | 12/31/2012 11:23:20 AM | mno | 12/31/2012 8:38:59 AM |
i need to calc the efforts of engineers that can be reducable in hours and the engineers that can be reducalbe when automation is yes
any solution guys?
any response guys?
Hi,
Is it possible to get a sample QVW?
I think the problem is people or at least me are struggling with what you are trying to achieve. If you could even just explained in English what you want. Maybe supply some example expect results so we can see what the final figures should be.
Mark