Skip to main content
Since 1.1.1 Fill in missing values by carrying the last observed value forward. Use in the same query as time_bucket_gapfill. locf cannot be nested inside another function call.

Arguments

NameTypeDefaultRequiredDescription
valueANY ELEMENT-The value to carry forward
prevEXPRESSION--If no previous value is available for gapfilling, use the prev lookup expression to get a previous value. For example, you can use prev to fill in the first bucket in a queried time range. The expression must return just a value (not a tuple as expected by the interpolate function) with the same type as the value parameter.
treat_null_as_missingBOOLEAN--When true, NULL values are ignored, and only non-NULL values are carried forward.

Returns

The gapfilled value. The return type is the type of value.