ExamGecko
Question list
Search
Search

List of questions

Search

Question 90 - Desktop Certified Associate discussion

Report
Export

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?

A.
New York, Massachusetts, Rhode Island
Answers
A.
New York, Massachusetts, Rhode Island
B.
California, Idaho, Nevada
Answers
B.
California, Idaho, Nevada
C.
Texas, New Mexico, Colorado
Answers
C.
Texas, New Mexico, Colorado
D.
North Carolina, South Carolina, Virginia
Answers
D.
North Carolina, South Carolina, Virginia
Suggested answer: B

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:

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.

asked 23/09/2024
Karlis Priede
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first