Sheet swapping and dynamic dashboards

Sheet swapping, sometimes also called sheet selection, is a technique in which views are dynamically shown and hidden on a dashboard, often with the appearance of swapping one view for another. The dynamic hiding and showing of views on a dashboard has an even broader application. When combined with floating objects and layout containers, this technique allows you to create rich and dynamic dashboards.

The basic principles are simple:

  • A view Collapses on a dashboard when at least one field is on Rows or Columns and a combination of filters or hiding prevents any marks from being rendered
  • Titles and captions do not collapse but can be hidden so that the view collapses entirely

Let's consider a simple ...

Get Learning Tableau 2019 - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.