Highlight the Highest and Lowest Points in a Tableau Line Graph 

🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6...
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/...
•Book an hour to work with Ollie: www.eventbrite...
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
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.
Resources:
•Example Tableau Workbook: public.tableau...
•How Tableau Table Calculations Work: onenumber.biz/...