You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
EmployeeInfo is the first table that is dragged to the canvas,
The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
Not all records have an exact match.
Which type of join should the analyst use?
You use a quick table calculation lo calculate the moving average of a measure named Sales.
You need to calculate the moving averages of the last three years.
Which setting should you change in the Table Calculation dialog box? {Click the appropriate Option in the Answer Area)
