Performance recorder in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows dashboard names and their load times in seconds, recorded by Tableau Performance Recorder.

Cell	Value
A1	Dashboard Name
B1	Load Time (seconds)
A2	Sales Overview
B2	3.2
A3	Customer Analysis
B3	4.5
A4	Profit Trends
B4	2.8

Formula Trace

AVERAGE([Load Time (seconds)])

Step 1: List of load times: {3.2, 4.5, 2.8}

Step 2: Sum of load times: 3.2 + 4.5 + 2.8

Step 3: Count of load times: 3

Step 4: Average load time = 10.5 / 3

Cell Reference Map

     A               B
1 | Dashboard Name | Load Time (seconds) |
2 | Sales Overview| 3.2                |
3 | Customer Analysis| 4.5              |
4 | Profit Trends | 2.8                |

The formula references the 'Load Time (seconds)' column cells B2, B3, and B4 to calculate the average.

Result

     A               B
1 | Dashboard Name | Load Time (seconds) |
2 | Sales Overview| 3.2                |
3 | Customer Analysis| 4.5              |
4 | Profit Trends | 2.8                |
5 | Average Load Time | 3.5             |

The average load time of 3.5 seconds is shown below the load times, summarizing dashboard performance.

Sheet Trace Quiz - 3 Questions

Which cells are used to calculate the average load time?

A B2, B3, B4

B A2, A3, A4

C A1, B1

D B1, B2, B3

Key Result

AVERAGE calculates the sum of values divided by their count to find the mean.