The calculation {FIXED [Customer ID], [Region] : COUNTD([Order ID])} is the correct one to use for this scenario. This Level of Detail (LOD) expression will calculate the distinct count of orders for each customer within each region, which is then averaged per month. This approach ensures that the average number of orders per customer is accurately calculated for each region and then broken down by month, aligning with the client’s expectations.

The approach of using user filters to control access to data on profitability for Groups 2 and 3, combined with a calculated field that restricts the visibility of profit value to only Group 2, aligns with Tableau’s best practices for managing content permissions. This method ensures that each group sees only the data they are permitted to view, with Group 1 not seeing any profitability information, Group 2 seeing both profit and profit margin, and Group 3 seeing only the profit margin without the actual profit values. This setup can be achieved through Tableau Server’s permission capabilities, which allow for detailed control over what each user or group can see and interact with 1 2 .

The discrepancy between the count of workbooks in the Connected Workbooks tab and the lineage count in Tableau Catalog can occur because of user permissions. In Tableau Data Management, the visibility of connected workbooks is subject to the permissions set by administrators. If a user does not have permission to view certain workbooks, they will not see them listed in the Connected Workbooks tab, even though these workbooks are part of the data source’s lineage and are counted in Tableau Catalog.

To improve the performance of a Tableau dashboard while maintaining accurate counts, particularly when dealing with unknown or NULL BrowserIDs in the data tables, the following steps are recommended:

Modify the Browser Table : Add a new row to the Browser Table labeled " Unknown, " assigning it a unique BrowserID, e.g., 0 or 4.

Update the Site Visitor Table : Replace all NULL BrowserID entries with the BrowserID assigned to the " Unknown " entry. This ensures every record in the Site Visitor Table has a valid BrowserID that corresponds to an entry in the Browser Table.

Change Referential Integrity Setting : Change the Referential Integrity setting from " Some Records Match " to " All Records Match. " This change assumes all records in the primary table have corresponding records in the secondary table, which improves query performance by allowing Tableau to make optimizations based on this assumption.

To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:

Compute Average Sales by Segment for Each Category and Year :

Open the CC workbook and navigate to the Categorical Sales worksheet.

Drag the ' Sales ' field to the Rows shelf if it ' s not already there.

Drag the ' Segment ' field to the Rows shelf as well, placing it next to ' Category ' and ' Year ' .

Right-click on the ' Sales ' field in the Rows shelf and select ' Quick Table Calculation ' > ' Average ' . This will compute the average sales for each segment within each category and year.

Create a Calculation for Year-over-Year Percentage Change :

Right-click in the data pane and select ' Create Calculated Field ' .

Name the calculated field something descriptive, e.g., " YoY Sales Change " .

Enter the formula to calculate the year-over-year percentage change:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales] )), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

Click ' OK ' to save the calculated field.

Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab :

Remove the original ' Sales ' measure from the view by dragging it off the Rows shelf.

Drag the newly created " YoY Sales Change " calculated field to the Rows shelf where the ' Sales ' field was originally.

Format the " YoY Sales Change " field to display as a percentage. Right-click on the field in the Rows shelf, select ' Format ' , and adjust the number format to percentage.

Save Your Changes :

From the File menu, click ' Save ' to ensure all your changes are stored.

To shape the data in the " US Population Estimates " data source and enter the total number of records into the " Total Records " parameter in Tableau Desktop, follow these steps:

Open the CC Workbook and Access the Worksheet :

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Population worksheet by selecting its tab at the bottom of the window.

Format and Shape the Data :

Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.

To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select " Change Data Type " if necessary.

Calculate Total Number of Records :

Create a new calculated field named " Total Records " . To do this, right-click in the Data pane and select " Create Calculated Field " .

Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.

Drag this new calculated field onto the worksheet to display the total number of records.

Enter the Value into the Total Records Parameter :

Locate the " Total Records " parameter in the Data pane. Right-click on the parameter and select " Edit " .

Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.

Save Your Changes :

From the File menu, click ' Save ' to ensure all your changes are stored.

To complete the Pareto chart in the " City Pareto " worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these steps:

Open the CC Workbook and Access the Worksheet :

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the City Pareto worksheet by selecting its tab at the bottom of the window.

Construct the Pareto Chart :

Ensure that sales data is aggregated by city. If not, drag the ' City ' dimension to the Columns shelf and the ' Sales ' measure to the Rows shelf.

Sort the sales data in descending order to properly align the cities according to their sales contribution.

To create a running total of sales, right-click on the ' Sales ' measure on the Rows shelf, select ' Quick Table Calculation ' , and choose ' Running Total ' .

Drag the ' Number of Records ' field to the Rows shelf next to the Sales running total. Right-click on it, select ' Quick Table Calculation ' , and choose ' Running Total ' . Set its calculation to ' Percent of Total ' from the ' Edit Table Calculation ' option to represent the percentage of cities.

Add Reference Lines for the Pareto Principle :

Click on the Analytics tab in the sidebar.

Drag a ' Reference Line ' element and drop it onto the chart area.

Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.

Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.

Adjust the Appearance of the Chart :

Format the reference lines by right-clicking on them, selecting ' Edit ' , and choosing a distinct style or color to make them stand out.

Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.

Save Your Changes :

From the File menu, click ' Save ' to ensure all your changes are stored.