Question: How would I set this up in Tableau? Question 1 : Bump chart You have been asked to help the Northwest National Park system to

How would I set this up in Tableau? Question 1: Bump chart
You have been asked to help the Northwest National Park system to find trends. Specifically, what do five-year visitation trends look like for the parks? Load the D.4 NW National Park Visitation 2001-2020 into your data sources. Drag Year into the columns and create an ad hoc calculation in the row: SUM(Visitor Count). Then drag Park Type and Year into the filters. Select ONLY the National Park park type and the years 2015-2019. We are purposely excluding 2020 due to the COVID19 pandemic shutdown of many parks. Drag Park Name onto Color in the Marks tab and Park Name onto Label. Make sure the marks type is set to Line. Edit the label so that it shows the Line Ends.
Graphical user interface, text, application
Description automatically generated
You should now have a bump chart that looks like this:
Chart, line chart
Description automatically generated
From this chart, we can see that Yosemite and Olympic are firmly the most visited with some ups and downs. Next, Joshua Tree is on an increase. The line that really sticks out is the Hawaii Volcanoes NP, it really took a big dip in 2018 and had a slow increase in 2019.
While this is helpful, the leadership has requested to see a chart with 20 years (2010-2019). They also want to see only National Parks with at least 500K visitors a year. Add both filters to your bump chart.
Question 1A: For the Hawaii Volcanoes NP, was there an increase or decrease between 2010 and 2017?
Question 1A Answer:
<>
Question 1B: What was the highest visitor count for Hawaii Volcanoes NP between 2010 and 2019?
Question 1B Answer:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!