3 Replies Latest reply on Dec 10, 2012 12:23 PM by Jonathan Drummey

    Count of orders by customer

    Jeffrey James

      I have the fields:

       

      order_id

      customer_id

      order_date

      order_total

       

      I want to create a table that shows for some given month

       

      # customers who bought 1x

      # customers who bought 2x

      # customers who bought 3x

      # customers who bought 4x or more

       

      I originally tried this:

      COUNTD(order_id) > 2

       

      But it gave me a true false calculation rather than a segment I can use. Any help would be great!

       

      Thanks,

       

      Jeff