2 Replies Latest reply on Jul 20, 2018 6:10 PM by sree isarana

    AAGR  calculation in Tableau for KPI

    sree isarana

      HI Team,

       

      I am trying to calculate the overall %  for the years in a single KPI .

      Need your inputs to populate the AAGR calcuation.

      Attaching the Excel file with sample data.

      Let me know which formula would be better.

       

       

       

      • Beginning value = $100,000
      • End of year one value = $120,000
      • End of year two value = $135,000
      • End of year three value = $160,000
      • End of year four value = $200,000
      • The formula to determine the percentage growth for the year is:
      • Percentage growth = (Ending value / Beginning value) -1
      • Thus, the growth rates for each of the years is as follows:
      • Year one growth = $120,000 / $100,000 - 1 = 20%
      • Year two growth = $135,000 / $120,000 - 1 = 12.5%
      • Year three growth = $160,000 / $135,000 - 1 = 18.5%
      • Year four growth = $200,000 / $160,000 - 1 = 25%
      • To find the AAGR, and analyst simply needs to find the average of these growth rates: AAGR = (20% + 12.5% + 18.5% + 25%) / 4 = 19%