ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale, but must be installed separately for self-hosted TimescaleDB. Click to learn more.
Normalize the provided metric based on reference date and days.
|Timestamp to normalize the metric with|
|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 month_normalize(1000,'2021-01-01 00:00:00+03'::timestamptz)
The output looks like this:
Found an issue on this page?Report an issue!