How to Compare This Year to the Average of the Previous 3 Years in Tableau

By: Eric Parker

Pro Headshot.jpg

Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can also sign up for a Tableau Office Hour to work with him directly!

Here's an interesting challenge; 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 video below to follow along and learn how to perform this calculation.

Want help on your own Tableau problem? Sign up for an office hour and we'll solve it quickly together!

Can Tableau Prep do Fuzzy Matching?

Tableau - How to Keep Only the Historical Trends of the Highest Current Values

0