Connect to the "Global Superstore" data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?
Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.
Drop the City to the view, and add the State to the Filter shelf and select North Carolina.
Also, drop the Order Date to the Filters and select year 2012, 2013, 2014
Now, drop the Profit field to the tooltip. As of now, your view should look like this:
Now, we have to find the total profit earned by all the cities in Wake County.
Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.
To show the County go to the Map->Map Layers.
Check County Names and County Borders.
the total profit earned by all the cities in Wake County is $403.
Which of the following is true about spatial files?
All are false here.
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm
How to rename the Measure Names field in Tableau?
Measure Names is Tableau generated field, so you cannot rename it.
Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?
First, find the distinct sports for each country:
It will be created as a Measure, move this to Dimension
Get the distinct countries:
drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.
Connect to the "Global Superstore" data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?
Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate
measures)
From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.
Hover on each of the boxes:
Median for the First Class and Same Day ship modes are 84.
Carlene
5 hours agoDenae
2 days agoCamellia
26 days agoVincenza
1 months agoMaira
1 months agoOlga
2 months agoMari
2 months agoKris
2 months agoRory
3 months agoRosita
3 months agoNatalie
3 months agoVan
4 months agoDeeanna
4 months agoCheryl
4 months agoDaniel
4 months agoErnie
4 months agoTwana
5 months agoLashawna
5 months agoOnita
5 months agoStefania
5 months agoTanesha
5 months agoRex
6 months agoElliot
6 months agoTorie
6 months agoInes
6 months agoBrice
6 months agoRory
7 months agoWillodean
7 months agoIrma
7 months agoLindsay
7 months agoLashawn
7 months agoDolores
8 months agoSylvie
8 months agoGracie
8 months agoBelen
10 months agoClemencia
11 months agoSherron
11 months agoQuentin
11 months agoAleshia
11 months agoEllsworth
12 months ago