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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/modeling/query-views/parameters/fill-fields",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# fill_fields

> Ensures that the query returns continuous values for specific dimensions, even when no underlying rows exist.

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

```yaml theme={null}
query:
  fill_fields: ["<view_name>.<field_name>", "<view_name>.<field_name>", ...]
```

## Properties

<ParamField path="query" type="object[]">
  An object containing the individual parameters that make up a query view's query definition.

  <Expandable title="query properties" defaultOpen="true">
    <ParamField path="fill_fields" type="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]`
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml title="Show all months in a 4 year period" highlight={7-10} theme={null}
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 ]
```