topic Re: Runtime average in QlikView https://community.qlik.com/t5/QlikView/Runtime-average/m-p/419478#M1160753 <HTML><HEAD></HEAD><BODY><P>why don't you calculate your duration time in load script as an aditional field</P></BODY></HTML> Mon, 10 Dec 2012 09:52:15 GMT 2012-12-10T09:52:15Z Runtime average https://community.qlik.com/t5/QlikView/Runtime-average/m-p/419477#M1160752 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I've two time stamp field for each record:</P><P>StartTime operation</P><P>EndTime operation</P><P></P><P>I needed to calculate the duration and I&nbsp; wrote&nbsp; Endtime - StartTime. Into my graph I see the correct value.</P><P>Now I would have the runtime avg for each document type, but I'm getting wrong values. I tried&nbsp; avg(Endtime - starttime), but it's wrong.</P><P></P><P>For example</P><P></P><P>SAles orders&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2h and 15 minutes</P><P>Invoices&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 minutes</P><P>purchase orders&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1h 12 minutes</P><P></P><P>...</P><P></P><P>How can I solve it ?</P><P>Help please</P><P>Thanks in advance</P></BODY></HTML> Sun, 09 Dec 2012 16:40:45 GMT https://community.qlik.com/t5/QlikView/Runtime-average/m-p/419477#M1160752 Anonymous 2012-12-09T16:40:45Z Re: Runtime average https://community.qlik.com/t5/QlikView/Runtime-average/m-p/419478#M1160753 <HTML><HEAD></HEAD><BODY><P>why don't you calculate your duration time in load script as an aditional field</P></BODY></HTML> Mon, 10 Dec 2012 09:52:15 GMT https://community.qlik.com/t5/QlikView/Runtime-average/m-p/419478#M1160753 2012-12-10T09:52:15Z