3 Replies Latest reply on Nov 23, 2018 7:40 AM by Shinichiro Murakami

    Cumulative Spendings Cohorts

    Marie Paturel
      Hello everyone,

       

      I am trying to carry out a cohort study, on the cumulative spendings of my customers.

       

      I have 2 groups of customers (Group1: customers from the commercial operation n ° 1 and Group2: customers from the commercial operation n ° 2) acquired over several weeks (my cohorts).

       

      I would like to calculate the average spend per customer for each of these groups, based on their lifetime.

       

      I am able to obtain this value for each cohort of my groups, but I would like to have the weighted average by the number of clients (in yellow) :

      Capture1.PNG

       

       

      Here are attached a twbx and Excel mock-up.

       

      Thanks in advance,