Use Multi-Select Sets in Tableau Calculations

Connect with us:
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  

Description:
Did you know you can reference Tableau Sets in calculations? Most Tableau users don't.

Referencing a set in a calculation provides you the ability to filter a calculation, rather than an entire worksheet, based on end-user selection.

Why is that valuable?

It provides the flexibility to calculate percent of total on the fly (e.g. what percent of total sales come from California) and the ability to compare two segments that may or may not have overlap (e.g. how do Furniture Sales in the West compare to Furniture and Office Supplies Sales in the East?).

Some people realize that you can filter a calculation in Tableau with a parameter, but few people realize you can do so with a set. The added benefit of providing a set control (instead of a parameter control) for your end user is the capability to select multiple values from a dropdown (whereas a parameter only allows for a single selection at a time).

Ready to add this powerful approach to your Tableau arsenal? Check out the video and related resources!

Resources:
•Access/Download Tableau Public workbook from video here: https://public.tableau.com/app/profil...
•Top 10 and Other Example: https://onenumber.biz/blog-1/2018/12/...
•Tableau Sets Webinar: Tableau Sets: a Comprehensive Guide Webinar: https://onenumber.biz/blog-1/2022/9/2...
•Ray Givler Benchmarker tool on Tableau Public: https://public.tableau.com/app/profil...
•Ray Givler LinkedIn:   / raygivler