7 Replies Latest reply on Mar 9, 2012 8:16 PM by Shawn Wallwork

    Determining basket size of customers

    Kevin Lee

      Hi,

       

      I'm looking to create a measure which is effectively the basket size of a customer, which can then be used for subsequent analysis.

       

      Specifically, from the attached Tableau file, I'd like to create a measure that calculates the basket size of each customer, and then create a histogram out of it with number of customers on the y-axis, and buckets of basket size (1, 2, 3 etc) - the ultimate question I'd like to answer is what is most common basket size for my customers in different cities. Unfortunately doing a simple number-of-records / customers isn't going to work, because that just averages across the population.

       

      Thanks!

       

      Kevin