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.

Practice

1. What is the main purpose of an area chart in Tableau?

easy

A. To show trends and the total amount by filling the area under a line

B. To display individual data points without connecting lines

C. To compare categories using bars of different lengths

D. To show relationships between two numerical variables using dots

Solution

1. Step 1: Understand area chart basics

   An area chart fills the space under a line to emphasize the magnitude of values over time or categories.

2. Step 2: Compare with other chart types

   Unlike scatter plots or bar charts, area charts focus on trends and totals by shading the area below the line.

3. Final Answer:

   To show trends and the total amount by filling the area under a line -> Option A

4. Quick Check:

   Area chart = filled trend line [OK]

Hint: Area charts fill space under lines to show totals [OK]

Common Mistakes:

• Confusing area charts with scatter plots
• Thinking area charts only show individual points
• Using area charts to compare unrelated categories

2. Which of the following is the correct way to create an area chart in Tableau?

easy

A. Drag a measure to Filters, a dimension to Pages, then select 'Line' mark type

B. Drag a dimension to Rows, a measure to Columns, then select 'Circle' mark type

C. Drag two measures to Rows and Columns, then select 'Bar' mark type

D. Drag a measure to Rows, a dimension to Columns, then select 'Area' mark type

Solution

1. Step 1: Identify correct field placement

   For area charts, a measure (numeric data) goes on Rows and a dimension (categories or time) on Columns.

2. Step 2: Choose the correct mark type

   After placing fields, select the 'Area' mark type to fill the area under the line.

3. Final Answer:

   Drag a measure to Rows, a dimension to Columns, then select 'Area' mark type -> Option D

4. Quick Check:

   Measure + Dimension + Area mark = Area chart [OK]

Hint: Measure on Rows + Dimension on Columns + Area mark [OK]

Common Mistakes:

• Using Circle or Bar mark types instead of Area
• Placing dimensions on Rows instead of Columns
• Not selecting the Area mark type after placing fields

3. Given a dataset with sales over months and product categories, what will happen if you create an area chart with Month on Columns, SUM(Sales) on Rows, and Category on Color?

medium

A. The chart will show stacked colored areas for each category over months

B. The chart will show separate lines without filled areas

C. The chart will show a single color area for total sales only

D. The chart will produce an error because color cannot be used here

Solution

1. Step 1: Understand field roles in area chart

   Month on Columns creates the timeline, SUM(Sales) on Rows shows total sales, and Category on Color splits the area by product categories.

2. Step 2: Visualize the result

   Each category's sales area stacks on top of others, showing contribution per month with different colors.

3. Final Answer:

   The chart will show stacked colored areas for each category over months -> Option A

4. Quick Check:

   Color by category = stacked colored areas [OK]

Hint: Color splits area into stacked parts by group [OK]

Common Mistakes:

• Expecting separate lines instead of stacked areas
• Thinking color only changes line color, not area
• Assuming color cannot be used with area charts

4. You created an area chart but the areas overlap and colors are not stacked. What is the most likely cause?

medium

A. The color field is missing or not assigned

B. The dimension is on Rows instead of Columns

C. The mark type is set to 'Line' instead of 'Area'

D. The measure is aggregated incorrectly

Solution

1. Step 1: Check the mark type

   If the mark type is 'Line', the chart shows lines without filled areas, causing overlap and no stacking.

2. Step 2: Confirm correct mark type for area chart

   Changing the mark type to 'Area' fills the space under the lines and stacks colors properly.

3. Final Answer:

   The mark type is set to 'Line' instead of 'Area' -> Option C

4. Quick Check:

   Line mark = no filled areas [OK]

Hint: Use 'Area' mark type to avoid overlapping lines [OK]

Common Mistakes:

• Ignoring mark type and blaming data placement
• Not assigning color field for stacking
• Misunderstanding aggregation effects on area charts

5. You want to compare monthly sales trends for two regions using an area chart in Tableau. Which approach best highlights differences clearly?

hard

A. Place Region on Columns, Month on Rows, and SUM(Sales) on Size with 'Circle' mark type

B. Place Month on Columns, SUM(Sales) on Rows, and Region on Color with 'Area' mark type

C. Place Month on Rows, Region on Columns, and SUM(Sales) on Rows with 'Bar' mark type

D. Place SUM(Sales) on Columns, Month on Rows, and Region on Detail with 'Line' mark type

Solution

1. Step 1: Set timeline and measure correctly

   Month on Columns creates the timeline axis, SUM(Sales) on Rows shows sales values.

2. Step 2: Use Region on Color with Area mark

   Assigning Region to Color splits the area chart into colored stacked or overlapping areas per region, making differences visible.

3. Final Answer:

   Place Month on Columns, SUM(Sales) on Rows, and Region on Color with 'Area' mark type -> Option B

4. Quick Check:

   Color by region + Area mark = clear comparison [OK]

Hint: Use color for groups and area mark for trends [OK]

Common Mistakes:

• Using Circle or Bar marks instead of Area
• Placing Region on Columns instead of Color
• Not using Month on Columns for timeline