Pareto analysis in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field that sums sales.

Tableau

SUM([1])

Drag options to blanks, or click blank then click option'

AProfit

BSales

CDiscount

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit instead of Sales

Using Quantity which counts items, not money

Using Discount which reduces price

The SUM function adds up all values in the Sales field, which is essential for Pareto analysis.

2fill in blank

medium

Complete the code to calculate the running total of sales.

Tableau

RUNNING_SUM([1])

Drag options to blanks, or click blank then click option'

ASUM(Sales)

BMIN(Sales)

CAVG(Sales)

DMAX(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG(Sales) which averages instead of sums

Using MIN or MAX which do not accumulate

RUNNING_SUM needs the total sales at each step, so SUM(Sales) is correct.

3fill in blank

hard

Fix the error in the calculated field to compute the percent of total sales.

Tableau

RUNNING_SUM(SUM(Sales)) / [1]

Drag options to blanks, or click blank then click option'

ATOTAL(SUM(Sales))

BAVG(Sales)

CSUM(Sales)

DWINDOW_SUM(SUM(Sales))

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM(Sales) which sums only current row

Using AVG(Sales) which averages instead of sums

Using TOTAL(SUM(Sales)) which is not valid in Tableau

WINDOW_SUM(SUM(Sales)) calculates the total sales over the window, needed for percent calculation.

4fill in blank

hard

Fill both blanks to create a calculated field that ranks products by sales.

Tableau

RANK_[1](SUM([2]))

Drag options to blanks, or click blank then click option'

ADESC

BSales

CASC

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Ranking in ascending order which reverses the order

Ranking by Profit instead of Sales

RANK_DESC ranks products from highest to lowest sales, which is typical for Pareto analysis.

5fill in blank

hard

Fill all three blanks to create a calculated field for cumulative percent sales.

Tableau

(RUNNING_SUM(SUM([1]))) / (WINDOW_SUM(SUM([2]))) * [3]

Drag options to blanks, or click blank then click option'

ASales

BProfit

C100

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit or Quantity instead of Sales

Forgetting to multiply by 100

This formula calculates the cumulative percent of sales by dividing running sum by total sum and multiplying by 100.