8 Replies Latest reply: May 4, 2016 1:52 PM by Sunny Talwar RSS

    Calculating client growth per month

    Maxime Dumas

      Hi,

       

      I am trying to calculate the client growth rate per month. I was able to get the period growth rate (for example, trailing 12 months):

       

      (Count({<$(=vMaxDate)>} distinct [Client ID]) - Count({<$(=vPeriodLowerBand)>} distinct [Client ID]))/Count({<$(=vPeriodLowerBand)>} distinct [Client ID])

       

      with vMaxDate = current date, vPeriodLowerBand = current date - 12 months

       

      But I need to create a bar chart with monthly rates. The x axis would be months for the past year, and the y axis the monthly growth rate.

       

      In other words, I would need to "aggregate" the rates by month instead of calculating for the whole period.

       

      Thanks!