Versions:

Time-weighted average functions

This section contains functions related to time-weighted averages. Time weighted averages are commonly used in cases where a time series is not evenly sampled, so a traditional average gives misleading results. For more information about time-weighted average functions, see the hyperfunctions documentation.

Some hyperfunctions are included in the default TimescaleDB product. For additional hyperfunctions, you need to install the Timescale Toolkit PostgreSQL extension.

Hyperfunction subfamilyHyperfunction typeAPI callToolkitExperimental
Time-weighted averagesAggregatetime_weight()
Accessoraverage()
Rolluprollup()

Found an issue on this page?

Report an issue!

Related Content