Storytelling with data in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Tableau

SUM([1])

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

AProfit

BCategory

CSales

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension like Category instead of a measure.

Using Profit or Quantity when the question asks for sales.

The SUM aggregation of the Sales field is used to show total sales in the bar chart.

2fill in blank

medium

Complete the code to filter the data to only include the year 2023.

Tableau

YEAR([Order Date]) = [1]

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

A2024

B2023

C2022

D2021

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a wrong year like 2022 or 2024.

Using the full date instead of just the year.

Filtering on YEAR([Order Date]) = 2023 restricts the data to orders made in 2023.

3fill in blank

hard

Fix the error in the calculated field to show profit ratio as a percentage.

Tableau

(SUM([Profit]) / [1]) * 100

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

ASUM([Sales])

BSUM([Quantity])

CAVG([Profit])

DCOUNT([Order ID])

Attempts:

3 left

💡 Hint

Common Mistakes

Using quantity or count instead of sales.

Using average profit instead of total sales.

The profit ratio is profit divided by sales, so the denominator should be SUM([Sales]).

4fill in blank

hard

Fill both blanks to create a filter that shows only categories with sales greater than 10000.

Tableau

IF SUM([Sales]) [1] [2] THEN 'Show' ELSE 'Hide' END

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

A>

B<

C10000

D5000

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' operator.

Using 5,000 instead of 10,000 as the threshold.

The condition SUM([Sales]) > 10000 filters categories with sales above 10,000.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns the profit ratio only for the 'Technology' category.

Tableau

IF [Category] = [1] THEN SUM([3]) / SUM([2]) ELSE NULL END

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

A'Technology'

BSales

CProfit

D'Furniture'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong category name or missing quotes.

Dividing profit by profit instead of sales.

The condition checks if the category is 'Technology'. Then it calculates profit ratio as SUM([Profit]) / SUM([Sales]). The else returns NULL.