7 Replies Latest reply on Feb 14, 2019 4:09 AM by Rachel Clemo

    Fixed LOD not returning constant value

    Rachel Clemo

      Capture.PNGHi Everyone

       

      I am getting some bizarre results in my LOD

       

      I would like to return the Cohort CountD of Customers e.g. equivalent to M0 Customers

       

      I have defined the cohort as the min order date per customer, Months since first order is the date diff between cohort month and order date

       

      as you can see rather than being constant number returned it is changing in some months - at a loss here other than maybe some issue with underlying data?

       

      COHORT CUSTOMERS:

       

      { FIXED [Cohort_Month]: COUNTD([Customer_ID])}

       

      COHORT MONTH:

      { FIXED [Customer_ID]: min([Order_Date])}

       

      MONTHS SINCE FIRST ORDER:

       

      datediff("month",[Cohort_Month],[Order_Date])