0
0
Tableaubi_tool

First Tableau visualization - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Concept Flow
Data Table
+---------+-------+
| Region  | Sales |
+---------+-------+
| North   | 1000  |
| South   | 1500  |
| East    | 1200  |
| West    | 1300  |
+---------+-------+

Formula: SUM([Sales])
  |
  v
Total Sales = 5000

Visualization: Bar Chart showing sales by region
We start with a simple sales data table by region. The formula sums all sales values to get total sales. Then we visualize sales by region as bars.
Formula
SUM([Sales])

This formula adds all the sales numbers from the Sales column.

Step-by-Step Trace
StepExpressionEvaluates ToExplanation
1[Sales] values: 1000, 1500, 1200, 13001000 + 1500 + 1200 + 1300List all sales values from the data.
21000 + 1500 + 1200 + 13005000Add all sales values to get total sales.
The final result of SUM([Sales]) is 5000.
Variable Tracker
VariableValue
[Sales]1000, 1500, 1200, 1300
SUM([Sales])5000
Key Moments
What does SUM([Sales]) calculate?
Which cells contain the sales data used?
What type of chart is used to visualize the sales?
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM([Sales]) calculate?
AThe average sales value
BThe total of all sales values
CThe highest sales value
DThe number of sales entries
Key Result
SUM([Sales]) adds all sales numbers to get total sales, which is then visualized as a bar chart by region.
Transcript
We start with sales data by region. The formula SUM([Sales]) adds all sales values: 1000, 1500, 1200, and 1300. Adding these gives 5000 total sales. This total and the individual sales are shown in a bar chart, where each bar's length matches the sales amount for that region.