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

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.)

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: