TODAY() not showing data when it was recalled in custom SQL

Published: 22 Aug 2022
Last Modified Date: 24 Aug 2022


When using a Calculated Field function TODAY() to be the default value of a Parameter and using the Parameter in Custom SQL, it will trigger the Calculated Field to show no value.


  • Tableau Desktop 2022.1.3
  • MySQL


Ensure the underlying Custom SQL query returns values in the table. 


The circular dependency is that TODAY(), and any other calculation formula, will return no results if the underlying Custom SQL query yields an empty table. And that Custom SQL query might be yielding an empty table because of the value of the parameter, which is set from the TODAY() formula.
Did this article resolve the issue?