Solved

# Cross-tab and Line Graphs with Averages

Posted on 2011-03-03

Having an issue with using an average formula in my cross-tabs and line graphs.

My formula to calculate average talk time is {table.talktime} / {table.interactions} where talktime is the total talk time in seconds and interactions is the number of interactions being handled.

The table looks similar to this:

INTERVAL TALKTIME INTERACTIONS

06:00:00 1/1/2011 0 0

07:00:00 1/1/2011 37250 36

08:00:00 1/1/2011 12697 13

09:00:00 1/1/2011 1462 2

Giving me a total talk time of 51,409 seconds across 51 interactions. Therefore, the average is about 1008.02 seconds.

If I drop my formula in the "summarized field" section of the crosstab, my average is displayed as 131.12. If I change the summary to a weighted average with table.interactions it's 759.04. Both are wrong.

However, if I simply drop {table.talktime} into the "summarized field" section with a weighted average with table.interactions, I get closer with 1600.76. But it's still not right. What can I do?

And then line graphs - I don't know how to do this either. Do i need to change my average formula to take in a "group by" value?