Total and average call duration

[#1]

Hi all,

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.

How to calculate?

[swuehl]

Try a straight table chart with dimension category, then two expressions

=Interval( Sum(timestamp) )         // assuming timestamp is holding your call duration

=Interval( Avg( timestamp) )