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/...

[@onenumbertableau]

Need help with your Tableau calculations? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163

[@ZzZzZiggy]

This "How To Tableau" playlist is blowing my mind! An honest to god treasure trove. Thank you so much for sharing all of these tips and tricks with us!

[@onenumbertableau]

Thank you so much, you're welcome! We share Tableau resources every week at our Newsletter: onenumber.biz/newsletter

[@tamaboy311]

Sorry for my ignorance but, can't you do that from the Labels in Marks? What would be the difference? Thanks for the video, super helpful.

[@onenumbertableau]

You can label the MIN and MAX values from labels but you can't call them out visually with different marks or colors from there!

[@hussainvali2577]

Really helpful. Thanks

[@onenumbertableau]

That's great to hear, you are welcome!