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.

month_normalize()