How to convert unix-epoch to human time in Tableau?

Question

In the Tableau, I have a column containing the timestamps in unix-time format, which I wish to convert it to Human time. Is it possible to use R script in Calculated Field for such time conversion?

Answer 1

• You should create a new calculated field like this:

New_date = dateadd('second',[Time],#1970-01-01#)

(or)

• if [Time] is in milliseconds then you need to just divide it by 1000 to convert to seconds before passing it to dateadd of course

You can enroll in this Best Tableau Training Course online by Intellipaat to learn basic and advanced Tableau.