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?


(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.