3 Replies Latest reply on Apr 20, 2018 10:09 AM by Shinichiro Murakami

    Sliding Dates in BCG Growth-Share Matrix

    Joshua Gearheart

      I've successfully created a BCG Growth Share Matrix in Tableau with ease using the outstanding Interworks guide below.


      This method works when there are two sequential dates (years in my case) filtered.  I would like to add a parameter that allows me to slide two year increments to see growth and share change over time.


      How do you setup a BCG Growth Matrix so that a parameter can be used to set any year and its year prior?


      *Note: that the previous year must be hidden for the view to display as desired*




      My experiments to solve this have led me to posts such as these below, but I'm having a hard time tailoring them to the BCG:


      a calculation for same period last year.

      Comparing 2 different periods on same data