Skip to main content
This parameter is useful useful when you want to use a query view as a base table for other date objects and want to ensure all dates are represented in the data set, avoiding any ad hoc date series building.
To fill, Omni requires knowledge of the beginning and end of the fill set (e.g., last 200 days). If the date series is unbounded on either side, Omni will not fill the dimension.

​
Syntax

fill_fields: [ <view_name>.<field_name>, ... ]

​
Properties

​
fill_fields
array
A list of dimensions, specified as view_name.field_name.

​
Examples

Fill date dimension in query view
query:
  fields:
    [ "lead.created_date[week]", lead.count ]
  base_view: lead
  filters:
    lead.created_date:
      time_for_duration: [ 30 weeks ago, 30 weeks ]
  fill_fields: [ "lead.created_date[week]" ]
  sorts:
    - field: lead.created_date[week]