KNOWLEDGE BASE

Unable to Use Boolean Fields as Filters or Dimensions


Published: 25 Jun 2013
Last Modified Date: 27 May 2016

Issue

Unable to drag a Boolean (True/False) calculated field from a secondary data source onto the Filters or Dimensions shelves.

Environment

  • Tableau Desktop
  • Blended data

Resolution

Use the following workaround.
  • Modify the calculation so that it no longer produces a calculated field of type Boolean.
For example, the following calculated field:

[Start Date] <=[Order Date]

Would become:

IF ( [Start Date] <=[Order Date] ) THEN 1 ELSE 0 END

Cause

Boolean fields from secondary data sources cannot be used as dimensions or filters.
Did this article resolve the issue?