Using "Compute compounded rate" Option Returns Uncompounded Results in the View

Published: 25 Apr 2017
Last Modified Date: 25 Apr 2017


When checking the option "Compute compounded rate" in a percent difference quick table calculation and selecting Relative To a specific value, then the results are the same as the percent difference. e.


Tableau Desktop


Option 1

From the Table Calculation window of the measure that is set to be compounded, use Relative to > First.

Option 2

  1. Click Analysis > Create calculated field...
  2. Name it and drag the field (that has the compounded rate quick table calculation applied) into the calculation editor.
    • Tableau Desktop will automatically generate the formula for the quick table calculation.
  3. Use the new calculated field in place of the field with the quick table calcuation.
  4. (Optional) Format the value to show as Percentage.


Our team is investigating this issue. 
Did this article resolve the issue?