0
0
Tableaubi_tool~10 mins

Why marks control visual encoding in Tableau - Formula Trace Breakdown

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sample sales data by product category

CellValue
A1Category
B1Sales
A2Books
B2100
A3Clothing
B3150
A4Electronics
B4200
Formula Trace
SUM([Sales])
Step 1: SUM([Sales])
Cell Reference Map
   A          B
1 Category   Sales
2 Books      100
3 Clothing   150
4 Electronics 200

[Sales] references cells B2, B3, B4
The formula sums the Sales column values from cells B2 to B4
Result
   A          B
1 Category   Sales
2 Books      100
3 Clothing   150
4 Electronics 200
5 Total      450
The total sales 450 is shown as the sum of all sales values in the data
Sheet Trace Quiz - 3 Questions
Test your understanding
Why do marks control visual encoding in Tableau?
ABecause marks store the raw data values
BBecause marks calculate the total sales automatically
CBecause marks represent each data point and determine how data is shown visually
DBecause marks create new data columns
Key Result
SUM aggregates values in a column to produce a total