fill_fields - Query views

Ensures that the query returns continuous values for specific dimensions, even when no underlying rows exist. Useful 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

object[]

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

Hide query properties

string[]

An array of field names, specified view_name.field_name.For date fields, append the time unit in square brackets. For example, users.created_at[year]

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 ]

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

fill_fields - Query views

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples