Level of Detail Expressions are one of the fundamental Tableau tools that every Tableau user should have in their toolbox. However, many people struggle to conceptualize how LODs work, or in what instances to use them.
All tagged FIXED Function
Here's an interesting challenges; how do you compare this year's values to the average of the previous 3 years in Tableau? The complex solution requires the use of the FIXED level of detail function. Watch the above video to follow along and learn how to perform this calculation.