Forum Discussion
Customer Stickiness - Last Purchase analysis
I wish to create a matrix that shows the number of customers that made purchases in a month while segmenting it against the last purchase date. April May June July August Sept 0-30 day...
Hi Anonymous ,
Please share some sample data so that we could test the formula.
Best Regards,
Jay
please find demo table as requested
| Billing Doc No | Billing Date | Sales Order | Sales Order Date | Customer Name |
| 29 | 12.04.2022 | 21 | 16.03.2022 | am |
| 30 | 07.05.2022 | 22 | 21.03.2022 | am |
| 31 | 16.04.2022 | 22 | 21.03.2022 | am |
| 31 | 16.04.2022 | 22 | 21.04.2022 | am |
| 32 | 14.04.2022 | 23 | 30.03.2022 | ch |
| 33 | 05.04.2022 | 24 | 31.03.2022 | ch |
| 33 | 05.04.2022 | 24 | 31.03.2022 | ch |
| 33 | 05.04.2022 | 24 | 31.03.2022 | ar |
| 34 | 12.04.2022 | 24 | 31.03.2022 | ar |
| 34 | 12.04.2022 | 25 | 31.04.2022 | ar |
| 34 | 12.04.2022 | 25 | 31.04.2022 | ar |
| 34 | 12.04.2022 | 25 | 31.04.2022 | ar |
| 34 | 12.04.2022 | 25 | 31.04.2022 | ar |
| 34 | 12.04.2022 | 25 | 31.04.2022 | ar |
| 34 | 12.04.2022 | 26 | 31.05.2022 | ar |
| 34 | 12.04.2022 | 26 | 31.05.2022 | ar |
| 34 | 12.04.2022 | 26 | 31.05.2022 | ar |
| 34 | 12.04.2022 | 26 | 31.05.2022 | ar |