KNOWLEDGE BASE

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


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

Issue

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.

Environment

Tableau Desktop

Resolution

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.

Cause

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