-
1. Re: Determining basket size of customers
Richard Leeke Mar 5, 2012 1:26 AM (in response to Kevin Lee)What do you mean by basket size? I guess you probably mean total items per customer across all products - but it's not obvious from the question or the sample data.
-
2. Re: Determining basket size of customers
Kevin Lee Mar 5, 2012 2:50 AM (in response to Richard Leeke)Hi Richard,
Thanks - yes, sorry for the lack of clarity - the sample I uploaded was a bit faulty!
What I'm looking for is, for example, you can see that customer KBJ0324583 (in the new twbx file) has purchased 2 different products, and 16 items in total, while customer KBJ0324592 has purchased only 1 unique product, 2 times.
Let me know if that makes more sense!
Kevin
-
Question.twbx.zip 11.1 KB
-
-
3. Re: Determining basket size of customers
Shawn Wallwork Mar 5, 2012 5:18 AM (in response to Kevin Lee)Hi Kevin, just to be clear you said:
the ultimate question I'd like to answer is what is most common basket size for my customers in different cities.
So in the pix below your most common basket size in Berlin is 2, right?
What's your most common basket size in, say London or Chicago? Or are you just want to rank them.
--Shawn
-
4. Re: Determining basket size of customers
Kevin Lee Mar 5, 2012 5:48 PM (in response to Shawn Wallwork)Hi Shawn,
Thanks for your questions - I'm sorry I've been so unclear!
What I envisage is to create a histogram of sorts, with number of customers on the y-axis, and buckets for number of unique products on the x-axis (nb, not number of total items). Hope this makes things a bit clearer!
Kevin
-
5. Re: Determining basket size of customers
Shawn Wallwork Mar 5, 2012 8:58 PM (in response to Kevin Lee)Kevin, either the attached workbook and the pix below is close to what you're looking for, or I'm completely lost! Note, I wasn't sure if you wanted use COUNTD() or COUNT of customers. You can change it in the 'Number of Customers' calculated field. Also the item bin size is set to 1 so it will show all the different basket sizes that are within each market.
Hope this is what you were looking for.
--Shawn
-
Question-SW.twbx.zip 17.6 KB
-
-
6. Re: Determining basket size of customers
Kevin Lee Mar 8, 2012 10:47 PM (in response to Shawn Wallwork)Hi Shawn,
Thanks - hadn't realised that it was as straightforward as you demonstrated!
Kevin
-
7. Re: Determining basket size of customers
Shawn Wallwork Mar 9, 2012 8:16 PM (in response to Kevin Lee)Whew! Glad it worked for you Kevin.
--Shawn