Normalize the provided metric based on reference date and days.

NameTypeDescription
metricfloat8
reference_dateTIMESTAMPTZTimestamp to normalize the metric with
daysfloat8Optional, 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!