ExamGecko
Question list
Search
Search

List of questions

Search

Question 92 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and find out which region was having the highest percentage of returned orders in 2013?

A.
Western US
Answers
A.
Western US
B.
Southern Africa
Answers
B.
Southern Africa
C.
Eastern Asia
Answers
C.
Eastern Asia
D.
North Africa
Answers
D.
North Africa
Suggested answer: B

Explanation:

Create a left outer join, so that we can calculate the percentage of the returned orders

Create a calculated field "% of returned orders":

Drop the Order Date to the filters shelf and select the year 2013

Drop the Region to the rows and % of returned orders to the Text:

asked 23/09/2024
Erik-Jan Brul
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first