7 Replies Latest reply: Feb 3, 2016 10:36 AM by Gysbert Wassenaar RSS

    Help counting/charting occurrences within data

      Hello,

       

      I have a transaction file with two fields: CustomerID and ItemID. Each line represents a single order/transaction, so a customer ID can show up multiple times. My thought was there would be a way to count/show the distribution of how many customers made 1 order, 2 orders, 3 orders, 4 orders, 5 orders...N orders. What I would like is a histogram/bar chart that details this (so first bar would be number of customers that made 1 order, second would be # of customers that made 2 orders, and so on). I have been playing around for a half day trying to figure it out and can't seem to get it. I'm pretty new so any help would be much appreciated!

       

      Thanks!