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*

       

      https://interworks.com/blog/rteufel/2017/10/13/how-create-bcg-growth-share-matrix-tableau/

       

      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