I am working on Tableau 8.0 trial version and connecting to Hive 0.10 version via ODBC connector (Live Connection)
I have a string field in Hive that contains date value.
Is there a way I could convert this string field to a date and then add yearly, quarterly, monthly rollup(s) on this field ?
I am able to create a calculated field - converting string to date and specifying the format
When I drag it into the Columns section - Tableau adds a year function to it but shows it in red with error message "The aggregation used for year of calculation1 is not supported by the data source"
Can't tableau perform this operation on the
Use DATE Function to convert it to date by extracting year,month,day for example if string format is of type  then the calculation would be DATE((left([date string]),4),+"-"+mid(([date string]),5,2)+"-"+right(([date string]),2))
hope it helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...