Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have calculated values for response time (during Business Hours) for tickets.
I want to present average response time per month.
I converted the timestamp values from 'hh:mm:ss' to minutes into a new variable (response_time_bh (min:))using this formula:
(Num#(Subfield(winc_response_time_bh,':',1)) *60
+ Num#(Subfield(winc_response_time_bh,':',2))
+ Num#(Subfield(winc_response_time_bh,':',3))/60
Then I can easily calculate the average response time in a table.
When i try to do the same in a graph it doesn't give the correct value.
Any suggestion how this can be solved?
Ticket ID | response_time_bh | response_time_bh (min) |
OP-000001700301 | 102:01:45 | 6 121,8 |
OP-000001697522 | 03:19:41 | 199,7 |
OP-000001689558 | 05:03:43 | 303,7 |
OP-000001665107 | 278:34:00 | 16 714,0 |
OP-000001655877 | 302:03:55 | 18 123,9 |
OP-000001653706 | 296:02:07 | 17 762,1 |
Hi!
I added this to the load script:
LOAD
(Num#(Subfield(response_time_bh,':',1)) *60
+ Num#(Subfield(response_time_bh,':',2))
+ Num#(Subfield(response_time_bh,':',3))/60)as new_response_time_min_bh
It works but the result is 'hh:mm:ss' and I don't thing I can calculate an average on that format.
Also the 'response_time_bh' is calculated in the load script with the format 'hh:mm:ss'
Hi!
After a closer look at this I can see that it's not working. The new variable is not created.
It seems as if you can't created a variable based on another variable in the load script