Question 12 - Salesforce Analytics-Con-301 Real Exam Questions [Feb 2026 Update]

Q: 12

SIMULATION From the desktop, open the CC workbook. Open the City Pareto worksheet. You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle. From the File menu in Tableau Desktop, click Save.

Your Answer

Correct Answer:

1. ON THE ROWS SHELF, RIGHT-CLICK THE SUM(SALES) PILL AND SELECT DUAL AXIS. 2. ON THE MARKS CARD, SELECT THE SUM(SALES) (2) TAB, AND CHANGE THE MARK TYPE TO LINE. 3. ON THE ROWS SHELF, RIGHT-CLICK THE SECOND SUM(SALES) PILL, SELECT ADD TABLE CALCULATION. FOR CALCULATION TYPE, SELECT RUNNING TOTAL. CHECK THE ADD SECONDARY CALCULATION BOX. FOR THE SECONDARY CALCULATION TYPE, SELECT PERCENT OF TOTAL. CLOSE THE DIALOG BOX. 4. ON THE COLUMNS SHELF, RIGHT-CLICK THE CITY PILL, AND SELECT MEASURE > COUNT (DISTINCT). 5. ON THE COLUMNS SHELF, RIGHT-CLICK THE CNT(CITY) PILL, SELECT PERCENT OF TOTAL. CLOSE THE DIALOG BOX. 6. FROM THE LEFT PANE, SELECT THE ANALYTICS TAB. 7. DRAG REFERENCE LINE ONTO THE VIEW AND DROP IT ON THE TABLE SCOPE FOR THE SUM(SALES) AXIS. IN THE DIALOG, FOR VALUE, ENTER 0.8. CLICK OK. 8. DRAG REFERENCE LINE ONTO THE VIEW AND DROP IT ON THE TABLE SCOPE FOR THE CNT(CITY) AXIS. IN THE DIALOG, ENTER 0.2. CLICK OK. 9. FROM THE FILE MENU, CLICK SAVE.

Explanation

This procedure correctly configures the Pareto chart. First, a dual-axis chart is created to overlay a line graph (for cumulative percentage) on the bar chart (for individual sales). Table calculations are then applied to both the sales measure and the city dimension to compute the running total as a percentage of the total. This creates the characteristic Pareto curve and the cumulative percentage axis. Finally, constant reference lines are added at 80% on the sales axis and 20% on the city axis to visually represent the Pareto principle (the 80/20 rule), which is the core requirement of the task.

References

1. Tableau Desktop and Web Authoring Help: Create a Pareto Chart. This official documentation outlines the step-by-step process for building a Pareto chart

including creating a dual-axis chart

adding a running total table calculation

and then adding a secondary percent of total calculation. The steps provided in the answer directly follow this documented procedure.

2. Tableau Desktop and Web Authoring Help: Reference Lines

Bands

Distributions

and Boxes. This document details how to add reference lines from the Analytics pane. Specifically

it covers adding a line for a constant value to an axis

as required by the prompt to show the 80% and 20% marks for the Pareto principle. (See section: "Add a Reference Line").

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE