# Amount of time spent reading by Discourse groups

**URL:** <https://meta.discourse.org/t/amount-of-time-spent-reading-by-discourse-groups/77702>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [10 يناير 2018، 9:41م UTC](https://meta.discourse.org/t/amount-of-time-spent-reading-by-discourse-groups/77702 "2018-01-10T21:41:16Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)\
**Post date:** [9 فبراير 2018، 6:44م UTC](https://meta.discourse.org/t/amount-of-time-spent-reading-by-discourse-groups/77702/4 "2018-02-09T18:44:48Z")

</div>

I’d be grateful for some help with creating this query - it’s not my forte and I’m not too proud to admit it. 👼

I used a spreadsheet yesterday to manually calculate the average amount of time spent reading by staff groups in my community, and it’s really quite interesting to understand how our community is using (or not using) discourse, and to nudge people to encourage their colleagues to log in and read more.

Last month I announced a “friendly competition” amongst staff groups to see which group can log the most time reading discussions. Here’s a post I just sent out announcing the winners, with some info redacted. People love it, I see lots of people logged in right now that I don’t usually see, and I want to do this every month from now on. 🚀

> Happy Forum Friday, everyone! Trust you are well and enjoying the discussions. (hint: the [most recent new member introductions topic](https://community.namati.org/t/what-are-you-working-on-8-feb-2018/41306?u=tobiaseigen) is amazing! A [topic on this week’s inspiring EJ webinar](http://topic) is also very popular, now with the full recording available and questions waiting to be answered.. )
> 
> **The results are in!** As of 8 February, the team that spends the most time reading forum discussions is… 🥁_drum roll_ 🥁 .. @group1. Congratulations! Your competitive streak and dedication is paying off. 🕶
> 
> | Namati team | Time spent reading since joining (average) | Time spent recently (average) |
> | --- | --- | --- |
> | @group1 | 113:06 | 6:46 |
> | @group2 | 45:00 | 2:20 |
> | @group3 | 15:26 | 0:59 |
> 
> I wonder which team will win next month? The time spent reading number above is an average, so if your team is near the bottom this month it is likely because some colleagues are not logging in. To win, urge your colleagues to log into [https://community.namati.org](https://community.namati.org) as frequently as they can to read discussions. There are some fabulous topics to look at - just go to [TOP](https://community.namati.org/top), choose a topic that looks interesting, and when you get to the bottom look at the next suggested topics, choose one to read, repeat. To paraphrase [Kid President](https://twitter.com/iamkidpresident/status/688399302364909569), “It’s like shampoo, but with your community!”
> 
> ![](https://global.discourse-cdn.com/meta/original/3X/9/4/94a287fc69ca38bea353ac88d0f1670ae3629e27.jpg)

---

_[View the full topic](https://meta.discourse.org/t/amount-of-time-spent-reading-by-discourse-groups/77702)._