medium10 pts · first answer countswindow-functionssqlcohort-analysis

Tagging rows with a cohort month

For a cohort analysis you need each order row tagged with the month of that customer's first order. Which expression works?

A.DATE_TRUNC('month', MIN(order_date) OVER (PARTITION BY customer_id))B.DATE_TRUNC('month', MIN(order_date) OVER ())C.DATE_TRUNC('month', order_date)D.DATE_TRUNC('month', LAG(order_date) OVER (PARTITION BY customer_id ORDER BY order_date))

Discussion 0

Join free to post in the discussion.

Tagging rows with a cohort month

Discussion 0

Related questions