KNOWLEDGE BASE

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


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

Issue

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.

Environment

  • Tableau Desktop 2022.1.3
  • MySQL

Resolution

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

Cause

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?