Area charts in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct use of area chart for cumulative sales

You have monthly sales data for a year. Which area chart best shows the cumulative sales over time?

A An area chart with months on the x-axis and monthly sales on the y-axis, but no cumulative calculation.

B An area chart with months on the x-axis and cumulative sum of sales on the y-axis, filled below the line.

C A bar chart with months on the x-axis and cumulative sales on the y-axis.

D A line chart with months on the x-axis and cumulative sales on the y-axis.

💡 Hint

Think about how area charts emphasize volume over time and how cumulative sums show total growth.

Option B correctly uses an area chart to show cumulative sales, filling the area under the cumulative sum line to emphasize total sales growth over time. Option B shows monthly sales, not cumulative. Options C and D use different chart types.

❓ dax_lod_result

intermediate

Calculate total sales for each category using LOD expression

Given sales data with categories and sales amounts, which Tableau LOD expression calculates total sales per category regardless of filters?

A { FIXED [Category] : SUM([Sales]) }

B { INCLUDE [Category] : SUM([Sales]) }

C SUM([Sales])

D { EXCLUDE [Category] : SUM([Sales]) }

💡 Hint

Think about which LOD expression fixes the calculation at the category level ignoring filters.

Option A uses FIXED LOD to calculate total sales per category regardless of filters. Option A includes category but respects filters. Option A excludes category. Option A is a simple sum affected by filters.

❓ data_modeling

advanced

Modeling data for stacked area charts with multiple categories

You want to create a stacked area chart showing sales over time by product category. What is the best data modeling approach?

A Aggregate sales by date only, ignoring categories, then use a stacked area chart.

B Create separate tables for each category and join them by date before charting.

C Pivot the data so each category is a separate column, then plot each as a separate area chart.

D Use a single table with columns for Date, Category, and Sales, then use Category as color dimension in the area chart.

💡 Hint

Think about how Tableau handles dimensions and measures for stacked area charts.

Option D is best because Tableau can stack areas by category when data is in a single table with category as a dimension. Option D complicates joins unnecessarily. Option D is less flexible and harder to maintain. Option D ignores categories, losing detail.

🔧 Formula Fix

advanced

Fix the issue with area chart not showing stacked areas correctly

Your stacked area chart shows overlapping areas instead of stacked. Which fix will solve this?

A Ensure the Category field is placed on the Color shelf and the Measure is on Rows shelf.

B Remove the Category field from the view and only use the Measure on Rows shelf.

C Change the chart type to line chart instead of area chart.

D Use a calculated field to sum all categories into one measure.

💡 Hint

Stacking depends on how Tableau assigns colors and dimensions.

Option A correctly assigns Category to Color, enabling Tableau to stack areas by category. Option A removes stacking dimension. Option A changes chart type. Option A merges categories, losing stacking.

🧠 Conceptual

expert

Best practice for using area charts in dashboards

Which statement best describes a best practice when using area charts in dashboards?

A Use area charts without axis labels to keep the dashboard clean and minimalistic.

B Use area charts for detailed comparisons of many categories with similar values to highlight small differences.

C Use area charts to show part-to-whole relationships over time with clear color distinctions and avoid too many categories.

D Use area charts only for categorical data without any time dimension.

💡 Hint

Think about clarity and readability in visualizations.

Option C is best practice: area charts work well for part-to-whole over time with distinct colors and limited categories. Option C can cause clutter. Option C reduces clarity. Option C misuses area charts which usually need a continuous axis like time.