Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
Answer(s): B
Drop the State field to a view, you will get >1k unknown. Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone. Also, drop the Order Date to the Filters Shelf and choose Years as:Check for the Year 2013.Drop the Sales field to the Label in the Marks card, your view should look like this:Now use the Lasso Selection tool from the Map tools:And create the group of states as per our answer options. Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.
I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don't need. For example - We don't have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it? Larger image
Go to Filter card options, and Select Only Relevant values
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, 2014Now, 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.
Connect to the "Significant Volcano Eruption" data source. What percentage of total deaths caused by volcanoes which were having a volcano index greater than 2 and elevation greater than 5000?
Answer(s): A
Create a calculated field as:Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.
Which of the following are true regarding parameter actions?
Answer(s): B,C,D
While creating the parameter action, it is not mandatory to specify the aggregation.All others are true.
https://help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm
Post your Comments and Discuss Tableau Desktop-Certified-Associate exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Desktop-Certified-Associate content, but please register or login to continue.