$densify

Reference type:Cheat sheetFormat:Syntax + example + use case

Reference group: Pipeline stages

What it does

Adds documents for missing values in a sequence.

Syntax

{$densify: { field, range, partitionByFields? }}

Use case

Fill gaps in time-series analytics.

Important notes

Verify server-version support.

$densify: practical example
{ $densify: { field: "day", range: { step: 1, unit: "day", bounds: "partition" } } }
💡 Explanation Adds documents for missing values in a sequence. When to use it Fill gaps in time-series analytics. Caution Verify server-version support.
Key Takeaways
  • Adds documents for missing values in a sequence.
  • Typical use: Fill gaps in time-series analytics.