ExamGecko
Question list
Search
Search

List of questions

Search

Question 61 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?

A.
3.43
Answers
A.
3.43
B.
3.56
Answers
B.
3.56
C.
4.02
Answers
C.
4.02
D.
3.39
Answers
D.
3.39
Suggested answer: B

Explanation:

Create a Calculation to get the first alphabet of the customer name.

Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:

asked 23/09/2024
Felix Imafidon
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first