Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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?


1 Answer

0 votes
by (47.2k points)
  • You should create a new calculated field like this:

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


  • 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. 

Related questions

Browse Categories