KNOWLEDGE BASE

"Exclude" LOD expression Provides Different Results with DATEPART vs datepart


Published: 19 Nov 2018
Last Modified Date: 12 Dec 2018

Issue

Exclude LOD expression displays different results in the view depending on whether DATEPART or datepart is used in the calculation. 
 
An example can be seen in the attached sample workbook.
 

 

Environment

  • Tableau Desktop

Resolution

As a workaround, perform one of the following options:
  • Use upper case function (DATEPART) to get the correct result.
  • Use the same format (uppercase or lowercase) in LOD expression and dimensions in the view.

 

Cause


Tableau performs case sensitive string comparison when determining what fields to exclude as part of an EXCLUDE LOD calculation. 

 
Did this article resolve the issue?