2 Replies Latest reply on Feb 25, 2016 10:32 AM by Sam Fleisher

    FIXED LOD expression to find min use date per each product type

    Sam Fleisher

      Hi,

       

      I am trying to use the fixed LOD expression to calculate the min use date for each customer for each product type.  Essentially, I am trying to get customers' first paid visit and often their first visit is free, so if I am able to see their first use date for each product type, then I can filter it to just paid visits.

       

      When I try this, I dont get the right answer:

       

      {FIXED uid, product_type: min(use_date)}