# Admin Panel Usage Export Missing Dates

**URL:** <https://meta.discourse.org/t/admin-panel-usage-export-missing-dates/35361>\
**Category:** Bug\
**Created:** [November 8, 2015, 8:46pm UTC](https://meta.discourse.org/t/admin-panel-usage-export-missing-dates/35361 "2015-11-08T20:46:03Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)\
**Post date:** [November 8, 2015, 8:46pm UTC](https://meta.discourse.org/t/admin-panel-usage-export-missing-dates/35361/1 "2015-11-08T20:46:03Z")

</div>

Hope this one is fairly self explanatory. Today I attempted to do some data analysis on the Discourse usage. Was trying to compare New Users with Unique Visits with Posts. I went into the admin panel, opened the usage view for each stat, switched the start date, and clicked export.

When attempting to combine the 3 stats in my spreadsheet, I realized that there was different amounts of data for each stat, and found that on days where the stat was 0 (mostly had this issue with new users), no data was listed, and it just “skipped” the date. This required me to manually go through 3 years of dates and add the missing date (with 0 for stat) to allow the data comparison to work.

Expected result: Data should export with all dates within range and 0 where applicable. Much easier to filter out 0s from data than to find missing dates and add them.

---

_[View the full topic](https://meta.discourse.org/t/admin-panel-usage-export-missing-dates/35361)._
