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 example with a view showing profit by Department and Category with a Department quick filter. The dashboard has been formatted (from the...
