I am reasonably certain that your strings are not getting converted correctly into a date format.
The reason is that f.e. 2017-2 could, for Tableau, conceivably be 2 week, 2 month, 2 quarter etc.
I cannot claim that this would be the most effective way of doing things, but manually converting your strings into dates, for example with "makedate" functions, is a way forward.
It should be pretty easy to use the MID function to slice your strings appropriately.
Your string field used as a date is not a common format. You can create a custom calc such as: DATEPARSE("yyyy-MM",[Datestring]) to get it as a date type/formatted correctly.
Hi Daniel ,
I am trying out date parse function .
In 9.2 is it supported ? because I am getting the error as "unknown function dateparse called "