1 Reply Latest reply: Dec 9, 2013 11:20 AM by Srikanth P RSS

    How calculate how many user has done the same number of order.

      Hi all,

      i have a problem calculating the number of user that have done an order.

       

      How i can calculate the next scenario?

       

      USER,   NUMBER ODER

      a               10

      b               4

      c               3

      d               10

      e               3

       

      I know that there are two user that have done 10 orders, two user that have done 3 orders and one that has done 4 orders.

       

      USER      NUMBER ORDER

      2               10

      2               3

      1               4

       

       

      The number od order is calculated with count(id_order) but how i can calculate the user?