Sheet swapping
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.
Let's start with some fundamental principles of sheet swapping.
Basic principles of sheet swapping
The basic principles are relatively simple. A view on a dashboard collapses when the following occur:
- At least one field is on rows or columns
- It is in a horizontal or vertical layout container
- It does not have a fixed height or width and the layout container is not set to distribute items equally
- A combination of filters or hiding prevents any marks from being rendered
Additionally, titles and captions do not collapse...