Year-Over-Year Calculation Does Not Compare Corresponding Date Parts With Incomplete Years

Published: 31 Jan 2013
Last Modified Date: 08 Jul 2022


When using the Year-over-Year Growth Quick Table Calculation on a series of years which are incomplete (ex. data for Q1, 2, and 3, but not Q4, etc.) the YoY% Growth calculation does not run on matching date parts.


Tableau Desktop


The example below uses Quarters as the datepart.
  1. On the Measure Values or Text shelf, right-click field with the table calculation, and select Edit in shelf.
  2. In the formula, change both instances of -1 to -4, and then click OK.
  3. Right-click the field again and select Edit table calculation.
  4. For At the level, select Quarter of Date, and click OK.


Tableau Desktop runs table calculations based on the index of the values in the view, instead of their actual associated date parts. This way one year may begin with January (month 1, value 1), another year may only have data starting with March (month 3, value 1). Because they are both value 1 per the index, the YoY% Growth will be run between January and March.
Did this article resolve the issue?