Hi all
I have the following data:
Date | Order ID | Customer Name | Product sub-category |
1/1/2015 | 1 | A | Computer |
1/1/2015 | 1 | A | Furniture |
1/1/2015 | 1 | A | Kitchenware |
1/1/2015 | 2 | C | Computer |
12/1/2015 | 3 | B | Furniture |
12/1/2015 | 4 | A | Kitchenware |
2/2/2015 | 5 | A | Computer |
3/2/2015 | 6 | B | Computer |
4/2/2015 | 7 | B | Furniture |
4/2/2015 | 7 | B | Kitchenware |
6/2/2015 | 8 | C | Kitchenware |
How can I reproduce a chart as shown below? I am hoping the values can be produced dynamically and not via scripting so that the numbers will change according to the filers chosen (i.e., when the user selects a particular month, the numbers will be updated automatically). However, if its not possible, do suggest how it can be done via scripting (granted flexibility will be lost).
Max* no. of different product sub categories ever purchased | No. of customers | Avg no. of purchases required | Avg no. of days required |
1 | 0 | 0 | 0 |
2 | 1** | 2 | 36 |
3 | 2*** | 2 | 12 |
* Max is evaluated over all the purchases and not just based on a particular Order ID ** Customer C *** Customer A and B |
The idea behind this is that it can help to inform:
1. customer purchase behavior (how many customers are really loyal to certain products of the company), or
2. "customer penetration" potential. I.e., which are the customers that the company should target to introduce a new product.
Thanks all!