By: Oliver Linley
Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.
Imagine you are building a line graph and want to visually call out the highest and lowest values for your end user. To do that, we can create a dual axis chart where circles representing the MIN and MAX points is overlaid on the line graph.
How can we calculate the highest and lowest values in a Tableau view? These values need to be dynamic (as we filter out info, the values need to change), and they need to be integrated into what we’ve already built. But how can we do that?
We’ll use a WINDOW function to achieve this! WINDOW functions are a sub-family of Table Calculations focused on aggregating the information within our window (or view), meaning that we can write calculated fields that deal with the data at an aggregated rather than row level. That allows us to ask which of the data points on the sheet is the minimum or maximum.
Not sure exactly how this all works? We'll walk through how to implement WINDOW functions into your Tableau work to find the highest and lowest values in your views.
Want help setting something like this up? Book an hour with Ollie! Want to dive deep into Tableau? Check out our upcoming Tableau classes!
Resources
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!