# Admin reports don't include dates with null values?

**URL:** https://meta.discourse.org/t/admin-reports-dont-include-dates-with-null-values/351928
**Category:** Data & reporting
**Tags:** dashboard-reports
**Created:** [February 12, 2025, 5:35pm UTC](https://meta.discourse.org/t/admin-reports-dont-include-dates-with-null-values/351928 "2025-02-12T17:35:58Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 6, 2025, 12:30pm UTC](https://meta.discourse.org/t/admin-reports-dont-include-dates-with-null-values/351928/2 "2025-06-06T12:30:36Z")

</div>

I think you should be able to recreate the #dashboard-reports in the [data explorer](https://meta.discourse.org/t/32566?silent=true) and add in a `generate_series` to populate a full list, including dates with no data.

You can find the SQL for the dashboard reports by browsing the #dashboard-sql tag, or there’s an overview in [Admin dashboard report reference guide](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233)

If you have a specific one in mind we may be able to give an example if you need one?

* * *

Also, there’s an existing #Contribute > Feature request to allow including ‘empty’ dates in the reports themselves if you’d like to add your vote to it:

> [@Add missing dates to report exports](https://meta.discourse.org/t/add-missing-dates-to-report-exports/245764):
>
> Since [I need to draw my own Trust Level Growth graph](https://meta.discourse.org/t/trust-level-growth-graph-mangled/217703), I decided to graph it against some other reports to see if there were any interesting patterns. So I export the data from 3 different reports & throw it all into the same spreadsheet… And see immediately that the columns - from across the same date ranges - aren’t the same length. It appears that when there’s no data for a day, the export simply omits the date. I spent a fair amount of time yesterday trying to line up the data sets (literal…

---

_[View the full topic](https://meta.discourse.org/t/admin-reports-dont-include-dates-with-null-values/351928)._