From the desktop, open the CC workbook. Open the Manufacturers worksheet. The Manufacturers worksheet is used to analyze the quantity of items contributed by each manufacturer. You need to modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression that calculates the percentage contribution of each manufacturer to the total quantity. Enter the percentage for Newell to the nearest hundredth of a percent into the Newell % Contribution parameter. From the File menu in Tableau Desktop, click Save.
Correct Answer:
See the complete Steps below in Explanation: Explanation: To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps: * Open the CC Workbook and Access the Worksheet: * Double-click on the CC workbook from the desktop to open it in Tableau Desktop. * Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window. * Modify the Percent Contribution Calculated Field: * Navigate to the Data pane and find the "Percent Contribution" calculated field. * Right-click on the "Percent Contribution" field and select 'Edit'. * Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer: {FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])} * This formula uses{FIXED [Manufacturer]: SUM([Quantity])}to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity {SUM([Quantity])}calculates the grand total across all manufacturers. The division calculates the percentage contribution. * Click 'OK' to save the updated calculated field. * Enter Percentage for Newell: * With the updated "Percent Contribution" field, drag it onto the view to update the chart or table. * Identify the value corresponding to 'Newell' in the updated visualization. * Round this value to the nearest hundredth of a percent as required. * Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell. * Save Your Changes: * From the File menu, click 'Save' to store all the modifications you have made to the workbook. References: * Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations. * Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis. By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity. Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.
Question 2
A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages. What should the consultant recommend to limit the data source for optimal performance?
Correct Answer: D
Question 3
A client wants to flag orders that have sales higher than the regional average. Which calculated field will produce the required result?
Correct Answer: C
Explanation: (Only visible for Exam-tests members)
Question 4
A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source. Which Tableau tool should the consultant use?
Correct Answer: B
Explanation: (Only visible for Exam-tests members)
Question 5
A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table. What should the consultant use to transform the table in the most efficient manner?
Correct Answer: A
Explanation: (Only visible for Exam-tests members)
