datetimetableau-apitime-format

Tableau - How to view time column up to 3 digit milliseconds?

I am working with a dataset in Tableau where I have a column [Time], which holds 'mm:ss:SSS' (minutes:seconds.milliseconds (up to 3 digits)).

However, when I cast the column to time data type, the digits truncate and does not allow me to see the milliseconds.

Does anyone know if Tableau supports 3 digit milliseconds? And how to do it?

What I want to achieve:

Column: 1:27.452 (string) Output: 0:01:27:452 (hours, minutes, seconds, milliseconds up to 3 digits)

What I get:

Column: 1:27.452 Calculated field: **DATEPARSE("mm:ss.SSS", [Time]) Output: 0:01:27

Thanks!

Solution

  • According to Tableau documentation you could use miliseconds with 000 format.