1 Reply Latest reply: Feb 28, 2012 11:33 PM by niranjan RSS

    Count Customer by Number of Visit

      Hi all,

       

      I'm trying to do the following measurement, but I'm not sure where to start:-

       

      Branch
      1 time2 times3 times> 3 times
      Branch A100 customers200 customers300 customers400 customers
      Branch B120 customers220 customers350 customers100 customers

       

      To get the number of visit per customer, I use the following expression:

      count(OrderID)

       

      So, how can I count the number of customer based on their visit?