I've two time stamp field for each record:
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.
SAles orders 2h and 15 minutes
Invoices 30 minutes
purchase orders 1h 12 minutes
How can I solve it ?
Thanks in advance