As the title suggests, this nifty trick has the dual purpose of allowing you to trigger sheet swaps using Dashboard Actions and, when two data sources contain different levels of Granularity, it lets you analyse at both levels (the Granularity of the Primary and Secondary data source). This is the ‘illusion of a Full Outer Join’…
A full description on exactly how to set this up, and some 'retail' specific use cases can be found on our new Data Animators Blog (...only a couple of articles atm, but plenty in the pipeline!)
Hope you find this useful, and interested to see other use-cases using this (or a derivation of) this technique.
Original Author: Simon Runc