Why performance ensures usability in Tableau - Formula Trace Breakdown

Sample Data

This data shows different Tableau dashboard elements and their load times in seconds.

Cell	Value
A1	Dashboard Element
B1	Load Time (seconds)
A2	Sales Overview
B2	2.5
A3	Customer Segments
B3	4.0
A4	Profit Analysis
B4	6.5
A5	Inventory Status
B5	1.8

Formula Trace

IF([Load Time (seconds)] <= 3, "Good Performance", IF([Load Time (seconds)] <= 5, "Moderate Performance", "Poor Performance"))

Step 1: Evaluate Load Time for Sales Overview: 2.5 <= 3

Step 2: Result for Sales Overview

Step 3: Evaluate Load Time for Customer Segments: 4.0 <= 3

Step 4: Evaluate Load Time for Customer Segments: 4.0 <= 5

Step 5: Result for Customer Segments

Step 6: Evaluate Load Time for Profit Analysis: 6.5 <= 3

Step 7: Evaluate Load Time for Profit Analysis: 6.5 <= 5

Step 8: Result for Profit Analysis

Step 9: Evaluate Load Time for Inventory Status: 1.8 <= 3

Step 10: Result for Inventory Status

Cell Reference Map

    A                 B
1 | Dashboard Element | Load Time (seconds) |
2 | Sales Overview   | 2.5                |
3 | Customer Segments| 4.0                |
4 | Profit Analysis  | 6.5                |
5 | Inventory Status | 1.8                |

The formula references the Load Time values in column B to determine performance categories.

Result

    A                 B                 C
1 | Dashboard Element | Load Time (s)    | Performance         |
2 | Sales Overview    | 2.5             | Good Performance    |
3 | Customer Segments | 4.0             | Moderate Performance|
4 | Profit Analysis   | 6.5             | Poor Performance    |
5 | Inventory Status  | 1.8             | Good Performance    |

The final result adds a Performance column categorizing load times as Good, Moderate, or Poor, showing how performance impacts usability.

Sheet Trace Quiz - 3 Questions

What performance category does a load time of 2.5 seconds fall into?

A Moderate Performance

B Good Performance

C Poor Performance

D No Performance

Key Result

IF load time <= 3 then Good, else if <= 5 then Moderate, else Poor Performance