Why choosing the right chart type matters in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a bar chart showing sales by category.

Tableau

SUM([Sales]) AS [1]

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

ASalesSum

BSumSales

CSalesTotal

DTotalSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using unclear or confusing aliases for measures.

The alias TotalSales clearly describes the sum of sales, making the chart easier to understand.

2fill in blank

medium

Complete the code to filter data for the year 2023 in a line chart.

Tableau

YEAR([Order Date]) = [1]

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

A2023

B2021

C2024

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong year or including quotes around the year.

Filtering for the year 2023 ensures the chart shows data only for that year.

3fill in blank

hard

Fix the error in the calculation to show average profit per region.

Tableau

AVG([1]) AS AverageProfit

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

ASUM(Profit)

BProfit

C[Profit]

D[AverageProfit]

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting brackets around field names.

Using nested aggregate functions incorrectly.

Using [Profit] with brackets is the correct syntax in Tableau calculated fields.

4fill in blank

hard

Fill both blanks to create a calculated field that shows sales growth percentage.

Tableau

([[1]] - [[2]]) / [[2]] * 100

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

ASalesCurrentYear

BSalesPreviousYear

CProfit

DSalesTotal

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping current and previous year sales fields.

Using profit instead of sales fields.

The formula calculates growth by subtracting previous year sales from current year sales, then dividing by previous year sales.

5fill in blank

hard

Fill all three blanks to create a filter that shows only top 5 products by sales.

Tableau

RANK(SUM([[1]])) <= [2] AND [[3]] IS NOT NULL

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

ASales

B5

CProduct

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using profit instead of sales for ranking.

Setting the rank limit incorrectly.

Not checking for non-null product names.

This filter ranks products by sales and keeps only the top 5 products with non-null names.