Identifying Data Characteristics
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi - I have a data set with customers and products (see picture for example) for a beginning and ending period. I'd like to identify certain characteristics including whether it is a new customer, new product, lost customer or lost product. Looking for a simple way to achieve that.
Customer | Product | Qt End | Qt Beg | New Customer | New Product | Discontinued Product | Lost Customer |
A | 1 | 1 | – | x | |||
A | 2 | 1 | 1 | ||||
A | 3 | – | 1 | x | |||
B | 2 | 1 | – | ||||
B | 3 | – | 1 | x | |||
C | 2 | 1 | – | x | |||
D | 2 | – | 1 | x |
Thanks in advance for the help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mimzz96
Can you provide a logic how the input beomes output you need?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I basically need it to be either a 1 or 0 for all categories, to use as a multiplier for sales...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mimzz96
I mean your output is the flag for below, right?
New Customer | New Product | Discontinued Product | Lost Customer |
How can we flag them? from your input
Customer | Product | Qt End | Qt Beg |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Customer A Product 1 is sold in End period but not beginning, so it is a new product but not a new customer (since customer A was in period beg and end)
Customer C is a new customer because in period end but not beg
Customer D is a lost customer because in period beg but not end
Customer A Product 3 is a discontinued product because it is sold in period beg but not in period end
