month_normalize()

Normalize the provided metric based on reference date and days.

Required arguments

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

Sample usage

Get the normalized value for a metric of 1000, and a reference date of January 1, 2021:

2. SELECT toolkit_experimental.month_normalize(1000,'2021-01-01 00:00:00+03'::timestamptz)

The output looks like this:

2. month_normalize

4. ----------------------

6. 981.8548387096774