topic Re: calculate average value on timestamp in a graph in App Development

calculate average value on timestamp in a graph

stekol61 — Fri, 24 Jan 2020 14:15:59 GMT

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

Re: calculate average value on timestamp in a graph

TimvB — Fri, 24 Jan 2020 15:10:36 GMT

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.

Re: calculate average value on timestamp in a graph

stekol61 — Mon, 27 Jan 2020 09:33:24 GMT

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'

Re: calculate average value on timestamp in a graph

stekol61 — Mon, 27 Jan 2020 12:00:40 GMT

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