# Data Explorer query help: metrics to understand unique individual participants

**URL:** <https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [October 19, 2017, 2:32am UTC](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385 "2017-10-19T02:32:40Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![vinothkannans](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vinothkannans/32/86465_2.png) [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\
**Post date:** [December 4, 2017, 10:18am UTC](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385/14 "2017-12-04T10:18:11Z")

</div>

> [@southpaw](#):
>
> I noticed that when the counts differ, the threads have had posts split off to new threads.

I tested this functionality. I am unable to reproduce it. As I described in previous post the counts are differ (for staffs) only if the topic had deleted posts.

> [@southpaw](#):
>
> No connection to cellular network… has 26 participants in the query results. The thread shows 24. Actual count: 26.

Like it named as “Frequent Posters” currently we only displaying top 24 users who frequently posted. So if a topic had more than 24 users it will filter and display only top 24 participants.

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385)._