# Average number of members' replies per topic (excluding staff)

**URL:** <https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618>\
**Category:** Data & reporting\
**Created:** [January 5, 2024, 11:35am UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618 "2024-01-05T11:35:24Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [January 10, 2024, 4:24pm UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618/11 "2024-01-10T16:24:26Z")

</div>

In that example, the `is_staff` bit is part of the function of this particular query. It’s specifically added here `SELECT user_id, true as is_staff` rather than coming from the database itself. It sets anyone from the group you designate as ‘staff’ so they can be split into the two result sets (staff posts versus non-staff posts). 🙂

So if you had a group for ‘employees’, which wouldn’t technically be site staff as the database sets them, you could still add them and they would go in the ‘staff’ bucket and not the ‘non-staff’ bucket.

---

_[View the full topic](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618)._