# Dashboard New Posts statistics broken

**URL:** https://meta.discourse.org/t/dashboard-new-posts-statistics-broken/352599
**Category:** Bug
**Created:** [February 16, 2025, 9:43pm UTC](https://meta.discourse.org/t/dashboard-new-posts-statistics-broken/352599 "2025-02-16T21:43:11Z")
**Posts on this page:** 1
**Showing post:** 17

<div class="post-metadata">

### Author: ![martin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/martin/32/491371_2.png) [@martin](https://meta.discourse.org/u/martin)
#### Post date: [March 3, 2025, 1:11am UTC](https://meta.discourse.org/t/dashboard-new-posts-statistics-broken/352599/17 "2025-03-03T01:11:51Z")

</div>

> [@Roi](#):
>
> The answer is empty. That would explain the empty box on the admin dashboard. But your wrote that there should be an SQL statement in the answer as well?

Ah sorry maybe I only saw it because I was running it locally. Try this:

```ruby
MethodProfiler.output_sql_to_stderr!
Report.find("posts", start_date: 4.weeks.ago, end_date: Time.zone.now).data

```

You will get a lot more noise of queries now, but the last few queries will be the ones from the report:

 ![image](https://global.discourse-cdn.com/meta/original/4X/d/5/b/d5b32d26259c2bab436297396432a416bb1d18d9.png)

---

_[View the full topic](https://meta.discourse.org/t/dashboard-new-posts-statistics-broken/352599)._