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

# AAGR  calculation in Tableau for KPI

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%
• ###### 1. Re: AAGR  calculation in Tableau for KPI

Hi, Sree

Is it something like below? if yes, please find attached workbook.

Hope this helps

ZZ

• ###### 2. Re: AAGR  calculation in Tableau for KPI

Thanks for the response.

I don't want to calculate in a chart. I want to show it as a KPI and at the same time when filter selections are made. it should change accordingly.

I have a year as a filter,

when two years are selected it should calculate as  (CY-PY)/PY*100= % value

if more than 2 years are selected then it should calculate as a average  as shown in the above

• When 3 years are selected
• Year one growth = \$120,000 / \$100,000 - 1 = 20%
• Year two growth = \$135,000 / \$120,000 - 1 = 12.5%
• Total  as  (20%+12.5%)/2 =16.1

Depending on the number of years selected the KPI overall value should change.