# 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:** [2017 年10 月 19 日 02:32 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:** 5

<div class="post-metadata">

作者： ![david](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/david/32/157490_2.png) [@david](https://meta.discourse.org/u/david)\
发布日期： [2017 年10 月 20 日 16:45 UTC](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385/5 "2017-10-20T16:45:05Z")

</div>

Unfortunately the only documentation is the code itself. I’m pretty sure participant\_count should be the number of unique posters…

> <https://github.com/discourse/discourse/blob/cf9607a0cb5753bdae1c756752021aeb2df3f264/db/migrate/20131114185225_add_participant_count_to_topics.rb#L6>

Do you have an example public topic where it doesn’t match up?

---

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