Why calculations extend data analysis in Tableau - Challenge Your Understanding

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this Tableau calculated field?

Consider a dataset with sales data. The calculated field is:

IF SUM([Sales]) > 1000 THEN 'High' ELSE 'Low' END

What will be the output for a region with total sales of 1200?

Tableau

IF SUM([Sales]) > 1000 THEN 'High' ELSE 'Low' END

A 'Low'

B SUM([Sales])

C 'High'

D 1200

💡 Hint

Think about what the IF statement checks and what it returns.

The calculation checks if the sum of sales is greater than 1000. Since 1200 is greater than 1000, it returns 'High'.

❓ data_output

intermediate

How many rows will the calculation add to the view?

You create a calculated field in Tableau that categorizes customers as:

IF [Profit] > 0 THEN 'Profitable' ELSE 'Not Profitable' END

If your data has 500 customers, how many rows will this calculation add to the view when used as a dimension?

Tableau

IF [Profit] > 0 THEN 'Profitable' ELSE 'Not Profitable' END

A 2

B 1

C 500

D Depends on the number of unique profits

💡 Hint

Think about how many unique categories the calculation creates.

The calculation creates two categories: 'Profitable' and 'Not Profitable'. So when used as a dimension, it groups customers into these two rows.

❓ visualization

advanced

Which option shows the correct use of a running total calculation in Tableau?

You want to create a running total of sales over months. Which calculated field expression correctly computes this?

A SUM(RUNNING_SUM([Sales]))

B RUNNING_SUM(SUM([Sales]))

C WINDOW_SUM([Sales])

D TOTAL(SUM([Sales]))

💡 Hint

Running total sums values cumulatively over a dimension.

RUNNING_SUM(SUM([Sales])) correctly computes the cumulative sum of sales over the partitioned dimension (e.g., months).

🧠 Conceptual

advanced

Why do calculations extend data analysis in Tableau?

Which of the following best explains why calculations extend data analysis in Tableau?

A They allow creating new data fields dynamically to reveal insights not present in raw data.

B They replace the need for data visualization by summarizing data in tables.

C They automatically clean and fix errors in the original data source.

D They limit the data to only numeric values for easier analysis.

💡 Hint

Think about how calculations add value beyond raw data.

Calculations let you create new fields and metrics that help uncover patterns and insights not directly visible in the original data.

🔧 Formula Fix

expert

What error does this Tableau calculation produce?

Consider this calculated field:

IF [Sales] > 1000 THEN 'High' ELSE END

What error will Tableau show when you try to use this calculation?

Tableau

IF [Sales] > 1000 THEN 'High' ELSE END

A Type error: Cannot compare string with number

B Runtime error: Division by zero

C No error, calculation runs fine

D Syntax error: ELSE clause missing expression

💡 Hint

Check the ELSE part of the IF statement.

The ELSE clause must have an expression. Leaving it empty causes a syntax error.