Good Morning Everyone,
I'm encountering an issue when connecting to an Excel workbook. I have several date time fields in mm/dd/yyyy hh:mm:ss AM/PM format. In the data preview screen within Tableau, I see the values as represented in Excel. However, when I add the field to a visualization in the workbook, Tableau has changed all of the time stamps to 12:00:00 AM.
Ideally I'd like to build a heat map showing activity by hours, but without the correct time stamps, my data points are useless for that purpose.
Any ideas would be most appreciated!
So it turns out that some of my date values were returning the error string #N/A. As soon as I corrected the underlying values, I was able to see the correct timestamps.