6 Replies Latest reply on Jun 11, 2019 11:22 PM by Hari Ankem

    How to calculate the number of visits needed to clock $x sales?

    Alicia Leong

      Hi all,

      I need to find out the number of visits each customer took in order to achieve $200, $300 and $500 total spend for our customer incentive program.

      The dates of visits have to be in ascending order of each customer so that running sum of sales would be logical. 

      I tried running sum, rank, but not able to find a solution. 

      I have attached a set of dummy data of customer sales.

      Hope someone in the community can have a solution.

      Thank you!

       

      CustomerNo of visitsParameter of total Spending
      John Doexx$200
      John Doexx$300
      John Doexx$500