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) :




      Here are attached a twbx and Excel mock-up.


      Thanks in advance,