The FIXED LOD expression fixes the calculation at the CustomerID level and returns the minimum OrderDate, which is the first purchase date for each customer.
A line chart showing retention over time by cohort clearly shows how each group of customers behaves month by month.
A star schema with a customer dimension and fact sales table allows easy calculation of first purchase and cohort grouping.
FIXED LOD fixes the first purchase month per customer, enabling cohort grouping. Then counting customers active in each month divided by cohort size gives retention rate.
{ FIXED [CustomerID] : MIN(OrderDate) }In Tableau, field names must be enclosed in square brackets inside LOD expressions. Missing brackets cause syntax errors.
