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: 11 Jan 2017

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 supported date functions can be used in calculated fields used for extract filters.
Did this article resolve the issue?