Ideally, this will be an integer, but it also works with Boolean data types – when we have only two sheets we want to swap – and, of course, with strings.
Put that calculated field onto Filter in the swapping sheets.Put that parameter into a calculated field.We switch, and the line chart for one KPI should become a bar chart for the other KPI.Įnter sheet swapping! How Sheet Swapping Works Unfortunately, we don’t want only the numbers to change but also the chart type.
Now, you may think, Just build a measure swap, right? Create a calculated field, and put a CASE statement in there that checks a parameter and gives us one of three measures. So, what to do? We want the user to see one chart at a time, not more. And as we know, overly busy dashboards are difficult to consume. But we have limited space, as there is not much real estate on a dashboard – either because there aren’t enough pixels (especially when viewing on a tablet) or because there is already too much going on. Let’s say we have three different KPIs and want to examine their timelines. We’ve built a dashboard and want to add more interactivity.
TABLEAU DESKTOP 2021.2 HOW TO
It seems we have so many articles explaining how to leverage sheet swapping, sharing certain specifics that have changed and reviewing when new Tableau versions came to be that we skipped over the foundational piece! So, let’s keep this brief and short: what is sheet swapping? This: This article may be a little bit late to the party, but hey, better late than never.