FILL IN THE BLANK - (Topic 2)
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

Solution:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the CategoryPercentage worksheet.
Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

1. A. (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
2. B. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
3. C. (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
4. D. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Correct Answer: B

- (Topic 3)
You have the following dashboard.

Currently the map is used as a filter that affects the data on the otter sheets of the dashboard
You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table
What should you do?

1. A. From the context menu of Sales over time select Ignore Actions
2. B. From the context menu of Sales over lime select Remove Dashboard Item
3. C. From the context menu of Profits by Stale deselect Use as Filter
4. D. From the context menu of Sales over time select Deselect

Correct Answer: A

HOTSPOT - (Topic 3)
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.


Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
You have the following dataset.


When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

1. A. Change the data type of the Sates field to Siring
2. B. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
3. C. Change the default number format of the Sales told
4. D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).

Correct Answer: C