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

bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation

%20dialog%20box%2C%20click%20OK.

Explanation:

Left join the Orders and Returns table

Diagram Description automatically generated

Number of orders returned will be order ID from the returns table divide by total orders

Graphical user interface, text, application, website Description automatically generated

Drop the customer name and ret order field in the view.

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

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

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