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

    Extract Hour from string

    Arvind Kumar

      All,

       

      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.