Hi Tableau Community!
I have a data set which has two separate attributes that I would like to combine into one single date attribute but I am running into some difficulties.
Attribute #1 is the month formulated as a string : ex. January, February, March, April, May, June, July, August, September, November, December
Attribute #2 is the year formulated as an integer: ex. 2015, 2016, 2017, 2018, 2019
How can I combine these attributes to form a Tableau date dimension which has 01/mm/yyyy format?
My solution was:
1. Create a calculated field called Date Type Month:
2. Create a second calculated field called Final Date:
MAKEDATE ([Year], DATEPART('month',[Date Type Month]), 01)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...