Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

This parameter is 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]