In Tableau, when would you use LOOKUP() versus WINDOW_AVG() in a table calculation?

Question

Tableau — Hard

In Tableau, when would you use LOOKUP() versus WINDOW_AVG() in a table calculation?

Accepted Answer

LOOKUP() and WINDOW_AVG() serve distinct purposes in table calculations. LOOKUP() retrieves a value from a specific offset position, while WINDOW_AVG() computes the average over a defined range. This distinction is crucial for accurate calculations.