FILL keyword

Queries using a SAMPLE BY aggregate on data which has missing records may return a discontinuous series of results. The FILL keyword allows for specifying a fill behavior for results which have missing aggregates due to missing rows.

Details for the FILL keyword can be found on the SAMPLE BY page.

To specify a default handling for null values within queries, see the coalesce() function documentation.