Statistical summary card in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data for 5 days

Cell	Value
A1	Sales
A2	100
A3	150
A4	200
A5	250
A6	300

Formula Trace

AVG(Sales)

Step 1: SUM(Sales)

Step 2: COUNT(Sales)

Step 3: AVG(Sales) = SUM(Sales) / COUNT(Sales)

Cell Reference Map

   A   
1 Sales 
2 100  
3 150  
4 200  
5 250  
6 300  

The formula uses all sales values from cells A2 to A6

Result

   A            B          
1 Sales       Average     
2 100        200          
3 150                   
4 200                   
5 250                   
6 300                   

The average sales value 200 is shown next to the sales data as a summary card

Sheet Trace Quiz - 3 Questions

What is the sum of the sales values?

A 1000

B 900

C 1100

D 1200

Key Result

AVG(column) calculates the average by dividing SUM(column) by COUNT(column)