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

Published: 11 Sep 2018
Last Modified Date: 19 Oct 2020


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.


  • Tableau Online
  • Tableau Server
  • Web Authoring


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

Discuss this article... Feedback Forum
Did this article resolve the issue?