# 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:** [10월 19, 2017, 2: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:** 1

<div class="post-metadata">

**Author:** ![southpaw](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/southpaw/32/79352_2.png) [@southpaw](https://meta.discourse.org/u/southpaw)\
**Post date:** [10월 19, 2017, 2:32오전 UTC](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385/1 "2017-10-19T02:32:40Z")

</div>

When I look at an individual topic, I can unfold a list of individuals who have posted on the topic, and the number of times they have done so:

 ![image](https://global.discourse-cdn.com/meta/original/3X/8/d/8d60b27bb39ada96a9c5c326bcc12ed2744cc010.jpg)

Could someone please help me build a query in [Data Explorer](https://meta.discourse.org/t/32566?silent=true) to determine:

- Average number of unique individuals per topic (day/week/month/year)
- Top-ten topics in the last day/week/month/year based on topics having the largest number of unique individual participants.

Thanks in advance.  
Southpaw

---

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