KNOWLEDGE BASE

NULL Value Disappears When Adding LOD Calculation


Published: 12 Mar 2018
Last Modified Date: 12 Apr 2018

Issue

When connecting to Google Bigquery, creating a view that has a dimension with a NULL value, and then adding a level of detail (LOD) calculation with a level of detail different than the view, then the NULL member disappears

Environment

  • Tableau Desktop 10.5.0-10.5.2 or earlier versions
  • Google BigQuery

Resolution

Option 1

Upgrade to Tableau Desktop 10.5.3. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Use table functions rather than LOD expressions.

Cause

This behavior is related to a known issue (ID: 717462) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?