# Top X posters in a given timeframe

**URL:** <https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [May 28, 2024, 3:17pm UTC](https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724 "2024-05-28T15:17:18Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![ecki](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ecki/32/264025_2.png) [@ecki](https://meta.discourse.org/u/ecki)\
**Post date:** [May 28, 2024, 3:17pm UTC](https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724/1 "2024-05-28T15:17:18Z")

</div>

Stupid question, is there an reason why there is no “Topics created by User in Timeframe” and “Posts created by User in Timeframe” reports? Seems to me its a commonly asked metric - who was most productive in a given timeframe. Or is that part of Discourse philosophy not to provide that easily?

I guess I have to dig into the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) for that? (especially to correlate it with “per company”?)

(I created that now with an Excel Pivot from the user export, but that only works for absolute not period numbers)

---

_[View the full topic](https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724)._