1 Reply Latest reply on Apr 13, 2018 4:13 PM by Hari Ankem

    Extract Hour from string

    Arvind Kumar



      I am a newbie.


      How can I extract hour from string data? I want to use it as a filter.



      some info on data


      its a year-long data with records in seconds.


      If I change the data type to date and time and then use the custom field to show it as hh, tableau shows error when trying to use that as a filter or row or column.


      Its a live connection and data is very big so difficult to work on extract.