Skip to main content
This is especially helpful for time-series data and is commonly used to show all months, days, or categories in a visualization, even when some buckets have zero records.

​
Syntax

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

​
Properties

​
query
object[]
An object containing the individual parameters that make up a query view’s query definition.

​
Examples

Show all months in a 4 year period
query:
  fields:
    users.age: age
    users.created_at[month]: created_at_month
    calc_1: calc_1
  base_view: users
  fill_fields: [ "users.created_at[year]" ]
  filters:
    users.created_at:
      time_for_duration: [ 4 years ago, 4 years ]