ExamGecko
Question list
Search
Search

List of questions

Search

Question 83 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many distinct customers have made 6 orders?

A.
29
Answers
A.
29
B.
30
Answers
B.
30
C.
31
Answers
C.
31
D.
None of the above
Answers
D.
None of the above
Suggested answer: A

Explanation:

Find out the distinct orders for each customer

Move this field from Measure to Dimension.

Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:

29 distinct customers have made 6 orders.

asked 23/09/2024
Isidre Piguillem
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first