KNOWLEDGE BASE

Incorrect Results When Filtering Dates in Year Over Year Calculation


Published: 28 Sep 2016
Last Modified Date: 25 Aug 2017

Issue

When filtering a Year Over Year calculation, some results might appear incorrect.

Environment

Tableau Desktop

Resolution

Instead of using a date field to filter, use the following calculation as a discrete pill on the filters shelf to remove the desired values.

LOOKUP(ATTR(year([<Date Field>]),0))

Cause

Table Calculations are computed after filters are computed. Using a calculation in the filters shelf ensures that the table calculation is performed first.
Did this article resolve the issue?