1 Reply Latest reply on Apr 1, 2016 6:50 AM by Takaaki Koseki

    Existing customers

    Brian Winkle

      I want to track existing customers over time. An existing customer is a customer that has made more than one purchase. Another discussion told me that in order to properly do this, I'd need to edit my data source to include a table of dates, which I have done.

       

      I have a New Customers chart which uses a LOD expression:

      { FIXED [Customer Id] : MIN( [Purchase Date] ) }

      to chart customers' first purchases. It doesn't seem like I can do this for existing customers, though, because if a customer didn't make a purchase in the time frame charted, they won't appear.