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.