Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a around 1lakh of data. I need to calculate the mean time to resolve for the overall tickets that are present in the dump.
for example:
Number | Opened | Closed |
---|---|---|
1022 | 3/18/2015 16:04 | 3/19/2015 23:55 |
1023 | 3/19/2015 7:25 | 3/19/2015 12:33 |
1024 | 3/16/2015 15:31 | 3/18/2015 9:20 |
1025 | 3/23/2015 8:15 | 3/24/2015 9:40 |
1026 | 3/23/2015 8:20 | 3/24/2015 9:40 |
1027 | 3/23/2015 8:33 | 3/24/2015 9:37 |
1028 | 3/23/2015 8:39 | 3/24/2015 9:40 |
1029 | 3/23/2015 8:42 | 3/24/2015 9:36 |
1030 | 3/23/2015 8:23 | 3/24/2015 9:40 |
1031 | 3/23/2015 8:24 | 3/24/2015 9:40 |
1032 | 3/23/2015 8:41 | 3/24/2015 9:34 |
1033 | 3/23/2015 8:44 | 3/24/2015 9:37 |
1034 | 3/16/2015 15:34 | 3/17/2015 12:28 |
thanks in advance
You mean something like this?
sum(Closed - Opened)/count(Number)
yes
I want it in hours
sum(Closed - Opened)/count(TOTAL Number)
Multiply by 24 .
it is working for me, thanks all