
1. Re: How to calculate daily averages of a retention matrix?
Łukasz Majewski Nov 18, 2016 11:35 PM (in response to Marcin Zwierz) 
2. Re: How to calculate daily averages of a retention matrix?
Marcin Zwierz Nov 21, 2016 7:00 AM (in response to Łukasz Majewski)Hi Łukasz,
preferably in the "Grand Total" row I would like to see the average retention calculated for each day. So for example for day 10 I would like to see 100% (or an empty cell because it's obvious that retention on the day of acquisition is 100%), for day 11 I would like to see (100% + 2%)/2 = 51% and so on. I tried using some tricks from Cohort Analysis  How to sum and average only valid values in table? but these do not work in conjunction with the LOD function..

3. Re: How to calculate daily averages of a retention matrix?
Łukasz Majewski Nov 21, 2016 8:05 AM (in response to Marcin Zwierz)OK, attached are 2 solutions:
1. Using your table calculations and customized totals:
2. Easy way  although LoD will affect performance more  by using LoD in the retention calc and optional aggregation for total:
Łukasz

Retention_Matrix_one_week.twbx 12.9 MB


4. Re: How to calculate daily averages of a retention matrix?
Marcin Zwierz Nov 22, 2016 5:58 AM (in response to Łukasz Majewski)That's super easy, works like a charm! Thank you so much!