How to Transform Datetime Tick into a Date Time Format using Tableau Calculations in Tableau Desktop
In this silent video, you’ll learn how to transform a datetime tick such as 635513268009600000 into a Date/Time format like 13/11/2014 18:20:00 using Tableau Desktop calculations.
Read the full article here: Transforming Datetime Tick into a Date Time Format using Tableau Calculations - https://kb.tableau.com/articles/howto...
- - - - - - - - - - - - - -
Encase a POWER() expression into a DATETIME() calculation. For example: DATETIME(([Time Dimension]* POWER(10, -7) / 60 / 60 / 24)-693593)
To build the view in the attached workbook Time Tic Example_v2019.1, please follow the steps below:
1. Create a Calculated Field named Calc1 and enter the following formula: DATETIME(([Time]* POWER(10, -7) / 60 / 60 / 24)-693593)
2. Right click this new calculated field and drag it to four (4) times on Columns, for each field select the following options:
Discrete YEAR(Calc1)
Discrete QUARTER(Calc1)
Discrete MONTH(Calc1)
Discrete DAY(Calc1)
3. Right click this new calculated field and drag it on Rows and select SECOND(Calc1)
4. Right click SECOND(Calc1) on Rows once more and select Discrete
5. (Optional) Drag Number of Records to Text
- - - - - - - - - - - - - -
Subscribe to the Tableau YouTube channel here: [link: http://www.youtube.com/subscription_c...]
Free Trial of Tableau: [link: https://www.tableau.com/products/trial ]
![roblox# 456 [ Undertale legacy Fight timeline 3 ] [ All Strong Character + All Ulter Character ]](https://images.videosashka.com/watch/08KOpc48-Qc)
