Admin reports don't include dates with null values?

[Justin_Gonzalez]

I’m trying to run before/after analytics to share with our leadership team, but I just noticed that if a date has a null value the report excludes that date, making the reporting inaccurate. Is this expected behavior? How can I get an accurate report to share with leadership? See the attached screenshot, where data for 1/18-1/20 is not reported.

[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…