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 also sign up for a Tableau Office Hour to work with him directly!
Need help with your Tableau calculations? Sign up for an office hour to work with Eric! Want to dive deep into Tableau? Check out our upcoming Tableau classes!
—
Groups are an incredible feature in Tableau, but they are limited. For instance, you can’t leverage a group for a blend or cross-database join.
If you need to use the output of a group for data preparation, you will probably want to turn it into a calculated field. Rather than doing it slowly by hand, why not leverage a quick formula which can speed up the process?
Check out the video below to learn how you can easily turn a group into a calculated field in Tableau.
Here’s the formula in Excel if you want to use it to get a head start!
=CONCATENATE("WHEN '",A2,"' THEN '",B2,"'")
Want to learn more? Check out our upcoming classes, webinars and office hours on Eventbrite!