Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Get started
Use Timescale
Services
Clouds and regions
Resources
PostgreSQL extensions
Connecting to Timescale
Hypertables
Distributed hypertables
Time buckets
Write data
Ingest data from other sources
Migration
Query data
Configuration
Schema management
Compression
Data retention
Continuous aggregates
High availability and replication
User-defined actions
Alerting
VPC
Backup and restore
Billing and account management
Metrics and logging
User Management
Upgrades
Hyperfunctions
About hyperfunctions
Function pipelines
Approximate count distincts
Statistical aggregates
Gapfilling and interpolation
Time bucket gapfill
Last observation carried forward
Percentile approximation
Counter aggregation
Time-weighted averages
Heartbeat aggregation
Troubleshoot hyperfunctions
Data tiering
Security
Timescale limitations
Troubleshoot Timescale
Tutorials
Code quick starts
API Reference
Other deployment options
About Timescale
Find a docs page
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