topic Total and average call duration in QlikView https://community.qlik.com/t5/QlikView/Total-and-average-call-duration/m-p/1095437#M363943 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have three categories, for each category i have duration in hh:mm:ss availabe in 400 rows so eventually i have 1200 rows data and two columns(category, timestamp), now i want total call duration and average for each category.</P><P></P><P>How to calculate?</P></BODY></HTML> Thu, 28 Jan 2016 18:24:37 GMT 2016-01-28T18:24:37Z Total and average call duration https://community.qlik.com/t5/QlikView/Total-and-average-call-duration/m-p/1095437#M363943 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have three categories, for each category i have duration in hh:mm:ss availabe in 400 rows so eventually i have 1200 rows data and two columns(category, timestamp), now i want total call duration and average for each category.</P><P></P><P>How to calculate?</P></BODY></HTML> Thu, 28 Jan 2016 18:24:37 GMT https://community.qlik.com/t5/QlikView/Total-and-average-call-duration/m-p/1095437#M363943 2016-01-28T18:24:37Z Re: Total and average call duration https://community.qlik.com/t5/QlikView/Total-and-average-call-duration/m-p/1095438#M363944 <HTML><HEAD></HEAD><BODY><P>Try a straight table chart with dimension category, then two expressions</P><P></P><P>=Interval( Sum(timestamp) )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // assuming timestamp is holding your call duration</P><P>=Interval( Avg( timestamp) )</P></BODY></HTML> Thu, 28 Jan 2016 19:00:43 GMT https://community.qlik.com/t5/QlikView/Total-and-average-call-duration/m-p/1095438#M363944 swuehl 2016-01-28T19:00:43Z