Definition of avg_time in topics table


(Holly Ross) #1

Hey there!

I’m working on some SQL queries to show the value of some of our proactive how-to content. I am pulling fields from the topics table to show the number of reads etc. I see there is an avg_time field and was wondering if that refers to the avg amount of time users spend on the topic? And if so, is that measure of seconds? minutes?

Thanks!


(Simon Cossar) #2

Yes, it returns the average time in seconds that people have spent reading the topic’s posts. The comment for the function that calculates the value says that it returns the ’ geometric mean’ of the posts’ timings.


(Holly Ross) #3

Thanks Simon - as I just admin the site, I can’t see comments in the code. It would be great to develop a data dictionary outside of the code base potentially.