Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Extract configured with a DATETIME increment key
Resolution
Option 1
Wrap the DATETIME
field in a truncate function at the datasource. For example:
TRUNC_TIMESTAMP([DATETIME])To view an example of the Trunc(date) function for Oracle Database: Database SQL Reference: Trunc* in the Oracle Knowledge Base.
Option 2
Convert the relevant table joins to CustomSQL to CAST the DATETIME key as a truncated DATETIME field.
To view an example of the CAST function see Database SQL Reference: Cast* in the Oracle Knowledge Base.
Option 3
Create a view at the data source. For more information, see Create a SQL View* (external site, w3schools.com).
*Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.
Cause
The date time field in the database is more precise than the date time that is recognized by Tableau Desktop.