month_normalize()
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.
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 month_normalize(1000,'2021-01-01 00:00:00+03'::timestamptz)
The output looks like this:
month_normalize----------------------981.8548387096774
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.