Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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?

image

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#)

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

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...