2 Replies Latest reply: Apr 15, 2016 4:43 AM by fredrik olsson RSS

    Count group by

    fredrik olsson

      Hi,

       

      I have a table with a lot of OrderData and I'm trying to find out how many customer who made one order, how many customers who made two orders and so on. I'm trying to group by / aggr on CustomerEmail but I don't get the result I'm looking for. Anyone that can point me in the right direction?  Thanks

       

       

      OrderIDCustomerEmail
      100mail1@mail.com
      101mail2@mail.com
      102mail3@mail.com
      103mail1@mail.com
      104mail1@mail.com
      105mail2@mail.com