This will convert that year to 1-Jan of that year. You can use it as date subsequently.
2 of 2 people found this helpful
You are correct but its still not sorting? Any Idea why?
No problems at my end.
It always helps if you share the workbook so others too can see what you are experiencing.
3 of 3 people found this helpful
I would say just wrap your current calc in FLOAT. String will not sort correctly, and in Tableau you sort dimnesions by measure, just you want to sort movies by year, converting the calc to float and dragging it to measures pane and then double clicking on the calc to bring it on the view and hitting the sort button should accurately work.
attached the workbook. please take a look. Shouldnt a Date type field sort properly.
Not sure what the problem is.