Get Tableau Certified

1. You want to create a calculation that will determine the first date that a customer placed an order. Which formula should you use?

2. You have a table with order data and wish to determine the number of unique orders. The same order can appear in multiple rows. What calculation should be used?

Row_ID	Order_ID	Customer_Name
32298	CA-2012-124891	Rick Hansen
26341	IN-2013-77878	Justin Ritter
25330	IN-2013-71249	Craig Reiter
13524	ES-2013-1579342	Katherine Murray
47221	SG-2013-4320	Rick Hansen
22732	IN-2013-42360	Jim Mitchum
30570	IN-2011-81826	Toby Swindell
31192	IN-2012-86369	Mick Brown

3. Which of the following is a table calculation? [select all that apply]

4. What steps should be taken to add a three month moving average to the line chart?

5. Which of the following will give different results for a given value of a depending on how the data is sorted?

6. The filter shows the top 5 customers by sales, but only two customers are showing. How can the viz be adjusted to show 5 customers?