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