calculate average value on timestamp in a graph

[stekol61]

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

[TimvB]

You can add the field "response_time_bh_min" to the script and then to the chart. This also improves the performance of the app as less calculations are needed in the UI.

[stekol61]

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' 

[stekol61]

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