I have attached a workbook with a calculation that turns your dates into a format which Tableau will recognize as dates in the way you need it to do so. For your reference, here is a KB article that has all of the date formats we can leverage: http://kb.tableausoftware.com/articles/knowledgebase/supporteddateformats
Hope this helps,
Dates.twbx.zip 8.1 KB
Thanks, I was thinking about doing something along those lines, I was just hoping Tableau could have figured it out by itself. Oh well this works great, thanks again!
I am trying to replicate the same workbook but unable to do so. Can you please let me know what I am missing.
The attached workbook has two data sources and I am trying to filter values based on Date. I need to filter the comments monthly based on the selection of the month bar. I am not able to get the date format correctly. The table I am pulling this data from has the following formats:
Please let me know how I can proceed.
Thanks for your time.
month.twbx.zip 19.8 KB