DATEPARSE and MAKEDATE should both still be available in Tableau 9. And yes, the sorting is because your dates are strings and not dates. Using one of the formulas to convert to a date should solve this.
What's your datesource as DATEPARSE and MAKEDATE aren't supported by all data sources?
My IT department says it is coming from a Greenplum database. And yes, both DATEPARSE and MAKEDATE do not work...weird
Are you connecting live or via an extract?
It's a live connection
1 of 1 people found this helpful
If both DATEPARSE() or MAKEDATE() are not working then you can use DATE() function.
Try this calculation
(CASE MID([Quarter Year],2,1)
WHEN "1" THEN "01" //"01 means January
WHEN "2" THEN "04" //04 means April
WHEN "3" THEN "07" //07 means July
WHEN "4" THEN "10" //10 means October
You can anchor your quarter month as per your financial start month.
then drag this to columns shelf and change it quarter year. See the screen shot.
Lets say this is your data
not sorted properly
Using calculated field
Hope this help. Let me know If you've any query.
DATEPARSE and MAKEDATE only work for specific connections. Greenplum doesn't appear to be one of those.
This article tells you about the supported connections for DATEPARSE: Understanding the DATEPARSE Function | Tableau Software
MAKEDATE only works for Tableau extracts: Date Functions
Therefore Mahfooj's suggestion of using DATE is the best way to go with your use case.