Empty reports where there should be data

[Moin]

Data explorer 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

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.