Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try a straight table chart with dimension category, then two expressions
=Interval( Sum(timestamp) ) // assuming timestamp is holding your call duration
=Interval( Avg( timestamp) )