KNOWLEDGE BASE

Error "Invalid field formula due to limitations in the data source" Using Calculated Field as Extract Filter


Published: 06 Jul 2016
Last Modified Date: 29 Jan 2019

Issue

When you try to use a DATEPARSE() calculation as an extract filter, the following error occurs:

Invalid field formula due to limitations in the data source.
Unable to properly calculate the domain for the field '<Field Name>'. Displayed data may be incorrect.

Environment

  • Tableau Desktop
  • All data sources except non-legacy Microsoft Excel and text file connections, MySQL, Oracle, and PostgreSQL

Resolution

Use DATE() instead of DATEPARSE().

Cause

Extract filters send queries directly to the database, therefore only functions supported by the data source can be used in the calculated fields used for extract filters.
Did this article resolve the issue?