Distribution analysis (box plots) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate the Interquartile Range (IQR) in Tableau

You have a dataset with sales values. You want to calculate the Interquartile Range (IQR) using Tableau calculations to create a box plot. Which calculation correctly computes the IQR?

A WINDOW_MEDIAN(SUM([Sales])) - WINDOW_AVG(SUM([Sales]))

B PERCENTILE([Sales], 0.75) - PERCENTILE([Sales], 0.25)

C MEDIAN([Sales]) - AVG([Sales])

D WINDOW_PERCENTILE(SUM([Sales]), 0.75) - WINDOW_PERCENTILE(SUM([Sales]), 0.25)

💡 Hint

Remember that IQR is the difference between the 75th and 25th percentiles over a window.

WINDOW_PERCENTILE calculates percentiles over the current partition. Subtracting the 25th percentile from the 75th percentile gives the IQR.

❓ visualization

intermediate

Identify the correct box plot visualization setup

You want to create a box plot in Tableau to analyze the distribution of sales by region. Which of the following steps is correct to build the box plot?

A Drag Region to Columns, Sales to Rows, then add Sales to Detail and use Analytics pane to add Box Plot.

B Drag Sales to Columns, Region to Rows, then create a calculated field for median sales and plot it as a bar chart.

C Drag Region to Filters, Sales to Tooltip, then create a histogram of sales.

D Drag Region to Rows, Sales to Columns, then use Show Me to select a scatter plot.

💡 Hint

Box plots require grouping by category and a measure on the axis, then adding the box plot from Analytics.

Dragging Region to Columns and Sales to Rows sets up the categories and measure. Adding Sales to Detail ensures data points are considered. The Analytics pane lets you add a box plot visualization.

🧠 Conceptual

advanced

Understanding outliers in box plots

In a box plot, how are outliers typically determined and displayed?

A Outliers are points outside 1.5 times the IQR above the third quartile or below the first quartile, shown as individual dots.

B Outliers are points beyond the maximum and minimum values, shown as bars.

C Outliers are points exactly at the median, shown as a line.

D Outliers are points within the whiskers, shown as shaded areas.

💡 Hint

Recall the standard rule for detecting outliers in box plots.

Outliers are values that lie beyond 1.5 times the IQR from the quartiles. They are shown as individual dots outside the whiskers.

🔧 Formula Fix

advanced

Fix the Tableau calculation for whisker limits

You wrote this Tableau calculated field to find the upper whisker limit for a box plot:
IF SUM([Sales]) < WINDOW_PERCENTILE(SUM([Sales]), 0.75) + 1.5 * (WINDOW_PERCENTILE(SUM([Sales]), 0.75) - WINDOW_PERCENTILE(SUM([Sales]), 0.25)) THEN SUM([Sales]) ELSE NULL END
But the whisker is not displaying correctly. What is the main issue?

A The 1.5 multiplier should be applied to the sum of percentiles, not their difference.

B WINDOW_PERCENTILE cannot be nested inside IF statements in Tableau.

C The calculation should compare individual row sales, not SUM([Sales]) aggregated over the window.

D The calculation should use MAX instead of IF to find the maximum value within the limit.

💡 Hint

Think about what level of aggregation is needed for the comparison.

The calculation compares the aggregated SUM([Sales]) which is the total over the partition, not individual row values. To find whisker limits, compare individual row sales values to the threshold.

🎯 Scenario

expert

Designing a dashboard with box plots for multiple categories

You need to build a Tableau dashboard showing box plots of sales distribution for multiple product categories and subcategories. Users want to filter by region and time period. Which approach best ensures accurate box plots and responsive filtering?

A Create separate worksheets for each category, add box plots individually, then combine them in the dashboard without filters.

B Create a single worksheet with Category and Subcategory on Columns, Sales on Rows, add box plot from Analytics, then add Region and Date filters to the dashboard with 'Apply to all worksheets'.

C Create a worksheet with Category on Rows, Sales on Columns, use a histogram instead of box plots, and add filters only for Region.

D Create a worksheet with Subcategory on Rows, Sales on Rows, add box plot, and use context filters for Region and Date.

💡 Hint

Think about how to build a flexible, filterable dashboard with multiple categories.

Using a single worksheet with both Category and Subcategory allows consistent box plots. Adding filters with 'Apply to all worksheets' ensures responsive filtering across the dashboard.

Practice

1. What does a box plot primarily show in data visualization?

easy

A. The total count of data points

B. The spread of data including median, quartiles, and outliers

C. Only the average value of the data

D. The correlation between two variables

Solution

1. Step 1: Understand box plot components

   A box plot displays the median, quartiles (Q1 and Q3), and any outliers in the data.

2. Step 2: Compare options to definition

   Only the spread of data including median, quartiles, and outliers correctly describes these features; others describe different charts or statistics.

3. Final Answer:

   The spread of data including median, quartiles, and outliers -> Option B

4. Quick Check:

   Box plot = median + quartiles + outliers [OK]

Hint: Box plots show data spread, not just averages [OK]

Common Mistakes:

• Confusing box plots with bar charts
• Thinking box plots show only averages
• Ignoring outliers in box plots

2. Which Tableau feature helps you quickly create a box plot?

easy

A. Using the 'Show Me' panel and selecting box plot

B. Writing a custom SQL query

C. Using the Data Interpreter tool

D. Applying a filter on the data source

Solution

1. Step 1: Identify Tableau tools for visualization

   Tableau's 'Show Me' panel offers quick chart types including box plots.

2. Step 2: Evaluate other options

   Custom SQL, Data Interpreter, and filters do not create visualizations directly.

3. Final Answer:

   Using the 'Show Me' panel and selecting box plot -> Option A

4. Quick Check:

   'Show Me' = quick box plot creation [OK]

Hint: Use 'Show Me' to pick box plot instantly [OK]

Common Mistakes:

• Confusing data preparation tools with visualization tools
• Trying to write SQL for box plots in Tableau
• Thinking filters create charts

3. Given a box plot in Tableau showing sales by region, what does the line inside the box represent?

medium

A. The average sales value

B. The maximum sales value

C. The median sales value

D. The total sales sum

Solution

1. Step 1: Recall box plot components

   The line inside the box is the median, which divides data into two equal halves.

2. Step 2: Differentiate median from average and extremes

   The average is the mean, not shown by the line; max is the whisker end; total sum is not shown.

3. Final Answer:

   The median sales value -> Option C

4. Quick Check:

   Box plot line = median [OK]

Hint: Median is the line inside the box, not average [OK]

Common Mistakes:

• Confusing median with average
• Thinking the line shows max or total
• Ignoring box plot whiskers

4. You created a box plot in Tableau but the whiskers are missing. What is the most likely cause?

medium

A. You forgot to add a measure to the Rows shelf

B. The data contains no outliers or extreme values

C. The data source is not connected

D. You applied a filter that removed all data

Solution

1. Step 1: Understand box plot requirements in Tableau

   Box plots need a measure on Rows or Columns to calculate quartiles and whiskers.

2. Step 2: Analyze each option

   No whiskers usually mean no measure is assigned; data connection or filters removing all data would prevent any plot.

3. Final Answer:

   You forgot to add a measure to the Rows shelf -> Option A

4. Quick Check:

   Missing whiskers = no measure assigned [OK]

Hint: Always add a measure to Rows or Columns for box plots [OK]

Common Mistakes:

• Assuming no whiskers means no outliers only
• Ignoring the need for measures in visualization
• Not checking data connection status

5. You want to compare sales distributions across multiple product categories using box plots in Tableau. Which approach best ensures clear comparison?

hard

A. Filter data to one category at a time and view box plots

B. Create separate worksheets for each category and compare manually

C. Use a pie chart to show sales proportions per category

D. Place product category on Columns and sales measure on Rows, then select box plot from 'Show Me'

Solution

1. Step 1: Set up box plot for multiple categories

   Placing product category on Columns and sales on Rows allows Tableau to create side-by-side box plots for comparison.

2. Step 2: Evaluate other options

   Separate worksheets or filtering one category at a time prevents direct visual comparison; pie charts do not show distribution.

3. Final Answer:

   Place product category on Columns and sales measure on Rows, then select box plot from 'Show Me' -> Option D

4. Quick Check:

   Side-by-side box plots = best for category comparison [OK]

Hint: Use Columns for categories and Rows for measure to compare box plots [OK]

Common Mistakes:

• Using pie charts instead of box plots for distribution
• Comparing categories in separate sheets
• Filtering to one category losing comparison context