Google Spreadsheet Post #1831
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov-13-2014
post by Joram030:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/pj5VX6XzkeE)Calculate customer churn
Hi,
I've got a dataset that looks like this:
| Customer | Period |
| a | 1 |
| b | 1 |
| b | 1 |
| c | 1 |
| d | 1 |
| a | 2 |
| b | 2 |
| d | 2 |
| e | 2 |
| d | 2 |
I'd like to calculate the number of unique customers that made a purchase in Period 1 but Not in Period 2.
Hope anyone can help!
Many thanks!
----------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment