# How do I get missing dates to show up in my results set?

**URL:** <https://community.omni.co/t/how-do-i-get-missing-dates-to-show-up-in-my-results-set/89>\
**Category:** Workbooks\
**Created:** [June 3, 2024, 5:52pm UTC](https://community.omni.co/t/how-do-i-get-missing-dates-to-show-up-in-my-results-set/89 "2024-06-03T17:52:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![conner](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conner/32/11_2.png) [@conner](https://community.omni.co/u/conner)\
**Post date:** [June 3, 2024, 5:52pm UTC](https://community.omni.co/t/how-do-i-get-missing-dates-to-show-up-in-my-results-set/89/1 "2024-06-03T17:52:44Z")

</div>

If you’re missing data for some dates in a given period, but you still want to have a row for each of the dates in that period, you can use Omni’s “Fill in Missing Rows” feature to fill in those dates. Just right-click the date field and hit “Fill in Missing Rows”. (If you’re not seeing the option to do so, check out [this post](https://community.omni.co/t/why-dont-i-have-the-option-to-fill-in-missing-rows/88).)

For example, maybe you want to plot the count of inventory items created per day in a given time period, but there are some days when no inventory was created. You can use dimension fill on the `created_date` field to fill in those missing dates: