ExamGecko
Question list
Search
Search

List of questions

Search

Question 43 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many new customers were acquired in the year 2014?

A.
4419
Answers
A.
4419
B.
5412
Answers
B.
5412
C.
4719
Answers
C.
4719
D.
5216
Answers
D.
5216
Suggested answer: A

Explanation:

If customer first order is equal to the order date, then this is the new customer.

Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a

'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer acquired in 2014.

Drop New Customer field to Rows and Unique customer field to Text marks card.

asked 23/09/2024
Arash Farivarmoheb
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first