Use TimescaleHyperfunctionsGapfilling and interpolation

Last observation carried forward

Last observation carried forward (LOCF) is a form of linear interpolation used to fill gaps in your data. It takes the last known value and uses it as a replacement for the missing data.

For more information about gapfilling and interpolation API calls, see the hyperfunction API documentation.

Keywords

hyperfunctionsToolkitgapfillinginterpolatelocfTimescaleManaged Service for TimescaleDBself-hosted TimescaleDB

Found an issue on this page?

Report an issue!
PreviousTime bucket gapfillNextPercentile approximation

Related Content

Gapfilling and interpolation
Fill gaps in time-series data
Time bucket gapfill
Fill in gaps within your time-series data when calculating time buckets
Hyperfunctions
Hyperfunctions help you perform critical time-series queries quickly
Statistical aggregation
Aggregate data to perform common statistical calculations in continuous aggregates and window functions
Percentile approximation
Approximate percentiles in large datasets
Function pipelines
Function pipelines improve the experience of writing data analysis queries in PostgreSQL and SQL