If private topics is enabled and the post is in a category where the plugin is enabled, it’s excluded, so it’s not counted
---
### Author:  [@tknospdr](https://meta.discourse.org/u/tknospdr)
#### Post date: [September 9, 2025, 4:58pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/5 "2025-09-09T16:58:11Z")
Crap, that’s the antithesis of what I need.
The only category that my boss cares about statistics for is our support forum, and that needs to be private for ticket segregation.
Is there any way to get stats on those posts?
---
### Author:  [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [September 9, 2025, 6:07pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/6 "2025-09-09T18:07:55Z")
[Data explorer](https://meta.discourse.org/t/32566?silent=true) should work to get the data. In this topic is the query which returns the post count per date like the dashboard report
> [@Dashboard Report - Posts](https://meta.discourse.org/t/dashboard-report-posts/288579):
>
> This is an SQL version of the Dashboard Report for Posts. This report provides a daily count of posts created within a specified date range. It is designed to track the activity in regular topics, excluding posts from private messages and other special archetypes. --[params] -- date :start\_date -- date :end\_date SELECT p.created\_at::date AS "Day", COUNT(p.id) AS "Count" FROM posts p INNER JOIN topics t ON t.id = p.topic\_id AND t.deleted\_at ISNULL WHERE p.created\_at::date BETWEEN :sta…
I think it won’t be affected by Private Topics, so it could work for you without changing anything.
---
### Author:  [@tknospdr](https://meta.discourse.org/u/tknospdr)
#### Post date: [September 9, 2025, 6:33pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/7 "2025-09-09T18:33:54Z")
That got me most of the way there, thanks.
I requested some additional parameters on that page to dial the query in more.
Seems like there’s enough people using Discourse as a ticketing system that it would be worthwhile to build a stats page to track things like time to first post after new topic created, and total elapsed time till topics are marked solved etc to better cover this use case.
---
### Author:  [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [September 9, 2025, 6:42pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/8 "2025-09-09T18:42:44Z")
> [@tknospdr](#):
>
> things like time to first post after new topic created,
There is an admin report for “time to first response”.
And there are also lots of other queries in #data-reporting
[Topics stats of Solved/Unsolved topics, inc. 'time to solution'](https://meta.discourse.org/t/topics-stats-of-solved-unsolved-topics-inc-time-to-solution/275393) is one you might be interested in. But I think it needs an update to reflect the changes on the solution plugin made in spring. [Time to first response by group members](https://meta.discourse.org/t/time-to-first-response-by-group-members/275118) and [Solved Topic and Moderator Response Stats by Category](https://meta.discourse.org/t/solved-topic-and-moderator-response-stats-by-category/302303) might also be interesting.
[ask.discourse.org](http://ask.discourse.org) is also very good at helping you to write queries that return the data you need
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [September 22, 2025, 2:20pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/9 "2025-09-22T14:20:15Z")
I shifted this topic across to #data-reporting so it can be pursued further here.
I agree that private posts should show up in reports, somewhere! It would be neat if the Posts report could have filters to show public or private posts, or both.
Well spotted that this has to do with the private topics plugin, @moin! 👏