We can rename the field from the metadata grid, but not the remote fields.

Remote field cannot be renamed by any means from Tableau

Refer: https://help.tableau.com/current/pro/desktop/en-us/forecast_create.htm

Go to the menu Dashboard - > Action - > Add Action

Select Filter, here you will find the Target Sheets

For all other options, you will not find the Target Sheets. Try it yourself.

Here we have to use the Obesity View only, so let’s go to that sheet:

Click on go to sheet as per above.

Edit the State filter and select only North Carolina:

Duplicate this sheet as Crosstab

3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity

rate.

Graphical user interface, text, application Description automatically generated

Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I

find it easy to get the answers.

Explanation :

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:

Graphical user interface, application Description automatically generated

Check for the Year 2013.

Drop the Sales field to the Label in the Marks card, your view should look like this:

Graphical user interface Description automatically generated with medium confidence

Now use the Lasso Selection tool from the Map tools:

Graphical user interface, diagram Description automatically generated

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.

Map Description automatically generated

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.

Graphical user interface, text, application Description automatically generated

Explanation :

Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Go to the Analytics tab and drop the Forecast to your view.

Right-Click on the view, Select Forecast - > Forecast Options. Change the Ignore last to 0 months,

Graphical user interface, text, application Description automatically generated

$35,152 is the correct answer.

Graphical user interface, chart, line chart Description automatically generated

Explanation :

All are false here.

Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm

Right Click on the Customer Name - > Create - > Set

Graphical user interface, text, application Description automatically generated

Create a calculated field:

Graphical user interface Description automatically generated

Drop the Top 20 by Sales set, Customer Name to Rows.

Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.

Graphical user interface, text, application, chat or text message Description automatically generated

Sort the Profit.

Table Description automatically generated

Explanation :

Select California State from the Map