The implementation is in our data warehouse, but I could probably share the SQL code if you’re interested. Could be translated to Postgres or whatever FOSS DB you prefer