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.