Desktop-Certified-Associate Exam Dumps : Tableau Desktop Certified Associate

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:

Create a calculated field as:

Graphical user interface, text, application Description automatically generated

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.

Graphical user interface, application Description automatically generated

Graphical user interface, application, table, Word Description automatically generated

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.