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

    Calculating client growth per month

    Maxime Dumas



      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.