month_normalize() ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.ExperimentalExperimental TimescaleDB Toolkit functions are not suitable for production environments. They may have bugs and may cause data loss. Click to learn more.
Normalize the provided metric based on reference date and days.
Name | Type | Description |
---|---|---|
metric | float8 | |
reference_date | TIMESTAMPTZ | Timestamp to normalize the metric with |
days | float8 | Optional, defaults to 365.25/12 if none provided |
Get the normalized value for a metric of 1000, and a reference date of January 1, 2021:
SELECT toolkit_experimental.month_normalize(1000,'2021-01-01 00:00:00+03'::timestamptz)
The output looks like this:
month_normalize----------------------981.8548387096774
Found an issue on this page?
Report an issue!Keywords