This content has been marked as final. Show 3 replies
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.