Sheet Swapping using Dashboard Actions (...or the Illusion of a Full Outer Join on Blended Data)

Version 4

    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’…


    This is different method to the great set of tricks in Sheet Selection on Steroids by Joshua Milligan


    Sheet Swapping on Action.png


    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!)


    Sheet Swapping using Dashboard Actions (or the Illusion of a Full Outer Join on Blended Data) | The Data Animators


    Hope you find this useful, and interested to see other use-cases using this (or a derivation of) this technique.


    Public Version:

    | Tableau Public


    Tableau Version:9.0


    Original Author: Simon Runc