Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've two time stamp field for each record:
StartTime operation
EndTime operation
I needed to calculate the duration and I wrote Endtime - StartTime. Into my graph I see the correct value.
Now I would have the runtime avg for each document type, but I'm getting wrong values. I tried avg(Endtime - starttime), but it's wrong.
For example
SAles orders 2h and 15 minutes
Invoices 30 minutes
purchase orders 1h 12 minutes
...
How can I solve it ?
Help please
Thanks in advance
why don't you calculate your duration time in load script as an aditional field