Admin reports don't include dates with null values?

[JammyDodger]

I think you should be able to recreate the dashboard-reports in the data explorer 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

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 #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

Since I need to draw my own Trust Level Growth graph, 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…