KNOWLEDGE BASE

Range of Dates filters do not exclude null values while web authoring


Published: 11 Sep 2018
Last Modified Date: 12 Oct 2018

Issue

While interacting with a published view in Web Authoring mode, null values are displayed after applying a Range of Dates filter to the rows shelf.

Environment

  • Tableau Online
  • Tableau Server
  • Web Authoring

Resolution

The ability to filter null values in Range of Dates filters while Web Authoring is not currently built into the Tableau Server/Online products.

Additional Information

The following options can be used to workaround the issue:

Option 1
Create the worksheet required within Tableau Desktop and then publish to Tableau Server/Online.

Option 2
Create a calculated field for use while Web Authoring in Tableau Server/Online. The script below provides an example and returns true/false values:
if isnull("date field")= true then false
else true
end
Did this article resolve the issue?