Ok, folks, I'm looking to take my workbook to the next level. I am analyzing 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 being aggregated together. Once I imported each data set separately, I then blended the data within Tableau to aggregate them together. 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 (television commercials and other targeted ads) causing attendance to significantly increase. The trend line really illustrates this increase nicely!
I want to learn what the effect of the "Utah's Big 5" promotion had on visitor attendance (beginning March 2013). To do this, 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, could be directly attributed to the "Big 5" marketing campaign.
I have already charted ACTUAL attendance growth in these parks, 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. I have also attached my workbook as well. Thanks in advance from your humble Tableau analyst in training!
Utah Big 5 National Parks.twbx 156.4 KB