5 Replies Latest reply on Mar 2, 2012 2:46 PM by Alex Kerin

    Simple question; count number of values for their last entry

    Samuel Jobin

      Hi

       

      I'm pretty new to Tableau and I'm still struggling even to create basic calculation, so bear with me here!

       

      I'm trying to count the number of user per number of purchases.  For example; my table would look like this:

       

      - userID 1, purchase 1

      - userID 1, purchase 2

      - userID 2, purchase 1

      - userID 1, purchase 3

      - userID 3, purchase 1

      - userID 2, purchase 2

      - userID 4, purchase 1

       

      End result should be something like this:

       

      number of purchase:  1 : 2 users

      number of purchase:  2 : 1 user

      number of purchase:  3 : 1 user

       

      Right now, I'm doing a countd on the number of user at each purchase, but it skew my data (in that example, I'm currently having 4 users that are in purchase 1).  I'm sure it's simple, but I can't figure it out yet! :S

       

      Thanks all in advance!

      Sam