View a markdown version of this page

fillmissing - Amazon CloudWatch Logs
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

fillmissing

Use the fillmissing command to insert rows for empty time bins after stats ... by bin(). You can optionally fill fields with a constant value.

Syntax

| fillmissing [with value for field [, value for field ...]]

The command uses the following arguments:

  • with value for field (Optional) – The constant value to assign to the specified field in the inserted rows.

Example

The following query fills empty 1-minute bins with 0 for the avg_latency field.

fields @timestamp, latency
| stats avg(latency) as avg_latency by bin(1m)
| fillmissing with 0 for avg_latency