Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions

Question

3 > O Actual direct-labour hours Standard direct-labour hours...

Answered: 1 week ago