1 Reply Latest reply on Feb 13, 2017 6:02 PM by lei.chen.0

    Proportion of customers with orders growing each month

    giles.somers.1

      Hi

      I have found the calculations for this to be particularly tricky

      I created a calc that returns a string for high, medium and low growth

      In addition, I want to allow for customers that order later

       

      ie. if 1 customer out of 100 orders in month 1 and so registers growth, I don't want to show this as 100% of customers growing

      Instead, I want to show that 1% is growing, 99% are not yet active

       

      To show the histogram, I need customer level details

      However, for the % figures, I also need to know the maximum count for all customers that ever order.


      Putting all of this together has me rather stumped, so I'd be grateful for any pointers please.

      Every option I try, seems to cause some knock-on issue


      Thanks

       

       

      Giles