1 of 1 people found this helpful
Pivot in Tableau.Then using month and year columns create a calculated field for the date using DATEPARSE function.
Like DATEPARSE('dd-MMM-yyyy','01'+'-'+[Month Field]+'-'+str([Year Field]))
Once its a date field, you have all those MY and other options readily available.
You could also use the Tableau reshape plug-in for Excel.
I'm not sure if the community still uses it but I do in my company as there are times when I like to prep the data in Excel and then bring it into Tableau.
It would result in the same pivot that you would achieve in Tableau.
Year Month Value
2016 Feb 20909
2016 Mar 29018
Now you can go ahead and create a date field in Excel itself or take into Tableau again
These are my suggestions and hope it helps.
Welcome to the community!
I used the first method to PARSE the date and it worked perfectly. I knew there had to be a way and a relatively easy one at that. Thanks so much. What a great introduction to this community. Best!
Welcome to the Forums Kevin! (Psst, don't forget to mark Aiswarya's answer correct.)
Yeah. I just went ahead and did it for him. No harm, no foul. We all took time to learn the ropes.
Ok, folks, I'm looking to take my workbook to the next level. I have imported visitor data for Utah's Big 5 national parks. I learned the hard way I had to import each of the parks data individually in order to pivot the data without it all being aggregated. I then had to blend the data within Tableau. All simple enough and I created three charts published here:
Tab 1: Simple attendance charts to illustrate relative attendance sizes of the 5 parks
Tab 2: Aggregated attendance trend over the past 30 years with a median attendance and trend lines
Tab 3: Aggregated attendance trend over the past 10 years with a line denoting BEFORE and AFTER the beginning of Utah's "Big 5" promotion with television commercials causing attendance to increase significantly. (The trend line really makes this case nicely!)
Here is what I'd like to do and I'm not sure how to do it, so if anyone can give me some direction I'll work on figuring it out.
I want to compare what the EXPECTED organic attendance growth would have been since March 2013 (based on the previous 7 years attendance) compared to the ACTUAL attendance growth since March 2013. The difference between these two variables, of course, can be attributed to the "Big 5" marketing campaign.
I have already charted ACTUAL attendance growth, so the real question is how to graph EXPECTED organic growth from March 2013 to present (based on the attendance data from January 2007-March 2013)? I know what I want to do, but I have no idea how to do this? I believe this would require a calculated field, but I'm not advanced enough to know how to do more than simple calculated expressions.
If I'm not clear or explaining myself correctly, please reply with any questions. Thanks in advance, your humble Tableau analyst in training!