Aggregate vs row-level calculations in Tableau - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Aggregate vs Row-Level Calculations

In Tableau, what is the main difference between aggregate calculations and row-level calculations?

A Aggregate calculations summarize data after grouping, while row-level calculations operate on each individual row before aggregation.

B Row-level calculations summarize data after grouping, while aggregate calculations operate on each individual row before aggregation.

C Aggregate calculations and row-level calculations both operate on individual rows but differ in syntax only.

D Row-level calculations are only used for filtering data, while aggregate calculations are used for creating new columns.

💡 Hint

Think about when the calculation happens: before or after grouping data.

Aggregate calculations summarize data after grouping, such as SUM or AVG, while row-level calculations work on each row individually before any aggregation.

❓ dax_lod_result

intermediate

Result of Aggregate vs Row-Level Calculation in Tableau

Given a sales dataset with columns Region and Sales, which Tableau calculation will return the total sales per region?

Choose the correct formula:

A IF [Sales] > 100 THEN [Sales] ELSE 0 END

B SUM([Sales])

C AVG([Sales])

D [Sales] * 2

💡 Hint

Think about which function aggregates sales per group.

SUM([Sales]) aggregates sales values per region. The others either operate row-level or calculate averages.

❓ visualization

advanced

Choosing the Right Calculation Type for a Dashboard

You want to create a dashboard showing average sales per customer and also highlight customers with sales above average. Which calculation types should you use?

A Use only aggregate calculations for both tasks.

B Use row-level calculation for average sales per customer and aggregate calculation to flag customers above average.

C Use only row-level calculations for both tasks.

D Use aggregate calculation for average sales per customer and row-level calculation to flag customers above average.

💡 Hint

Average sales per customer is a summary, flagging is per row.

Average sales per customer requires aggregation. Flagging customers above average is a row-level check against that aggregate.

🔧 Formula Fix

advanced

Debugging a Calculation Mixing Aggregate and Row-Level Functions

Consider this Tableau calculated field: [Sales] / AVG([Sales]). What issue will this cause?

A It will return the total sales divided by the average sales for the entire dataset.

B It will calculate the ratio correctly for each row without issues.

C It will cause an error because you cannot mix row-level and aggregate calculations directly.

D It will ignore the AVG function and treat both as row-level.

💡 Hint

Think about how Tableau handles mixing aggregation levels in one formula.

Tableau requires aggregate and row-level calculations to be separated properly; mixing them directly causes an error.

🎯 Scenario

expert

Scenario: Optimizing Performance with Calculation Types

You have a large dataset and need to calculate the percentage contribution of each product's sales to the total sales. Which approach is best for performance and accuracy?

A Use an aggregate calculation to sum sales per product and then divide by the total sales calculated as a separate aggregate in Tableau.

B Calculate percentage contribution using only row-level calculations without aggregation.

C Use a row-level calculation to divide each product's sales by the total sales aggregated once at the data source level.

D Calculate total sales per product using row-level calculations and total sales using aggregate calculations in the same formula.

💡 Hint

Consider where aggregation happens and how to avoid repeated calculations.

Summing sales per product and dividing by total sales as separate aggregates in Tableau optimizes performance and ensures accuracy.