By: Eric Parker
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 follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!
Do you want to keep all data associated with a value which has multiple records in a data set? Maybe it's how many students attended multiple schools, how many patients visited a hospital multiple times or how many customers made multiple purchases.
This is a key type of filter you might want to create and use in Tableau!
As long as you are showing all the data (e.g. count of orders by customer), you should be able to filter on an aggregated measure, no problem. What about once you try to drill into the details though? When you try to look at the details behind those records, the filter likely no longer accomplishes what you hoped.
Check out this week's video to learn how you can use Level of Detail Expressions in Tableau Desktop to filter and keep all data associated with a value which has multiple records, regardless of how you are viewing the data!
Access/download the Tableau Workbook from the demo here.
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!