month_normalize()

Normalize the provided metric based on reference date and days.

Required arguments

Sample usage

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

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

The output looks like this:

month_normalize
----------------------
981.8548387096774