4 Replies Latest reply on May 8, 2018 11:37 AM by Trey Weeks

    Create Index by dividing by Grand Total

    Trey Weeks

      I am not sure how to exactly express my problem but I will start by referencing the thread I am trying to replicate: Create index by dividing by grand total

       

      I want to create an index for any given metric (in this attached workbook example, engagement rate, conversion rate, take rate, system availability). The attached thread only uses sales, however I want to accomplish the same thing but by using any metric available in my data source. To calculate the index, I want to do (Metric/Metric Grand Total) * 100 so the index value of the "grand total" will always equal 100.

        • 1. Re: Create Index by dividing by Grand Total
          Shinichiro Murakami

          HI Trey

           

          Yours are connected to server and we cannot see the viz.

          Cold you please extract data before creating twbx.

           

           

          Thanks,

          Shin

          • 2. Re: Create Index by dividing by Grand Total
            Trey Weeks

            Oh yes apologies for that, here is the updated workbook along with a sample of what I am trying to accomplish.

             

                  

                                                                                                Raw Data
            AirlineAirlineAirlineAirlineAirlineAirlineAirlineAirlineAirlineAirline
            AALACAAMXASABAWDALGLOUALVIRGrand Total
            Engagement Rate18.05%8.22%9.07%30.76%1.25%21.76%14.05%22.29%8.05%19.92%
            IFC Take Rate7.76%2.64%1.63%13.45%10.26%11.05%2.06%4.05%3.86%8.73%
            Sessions18,152,899781,75762,4065,603,17538,47526,501,682390,5761,531,509134,54453,197,023

             

             

             

             

             

                                                                                 Index - What I want to Automate

            AirlineAirlineAirlineAirlineAirlineAirlineAirlineAirlineAirlineAirline
            AALACAAMXASABAWDALGLOUALVIRGrand Total
            Engagement Rate90.6124541.2650645.53213154.41776.2751109.2369570.53213111.897640.41165100
            IFC Take Rate88.88888930.2405518.67125154.0664117.5258126.5750323.5967946.3917544.21535100
            Sessions34.12391.469550.11731110.532870.07232549.8179790.7342062.8789370.252916100
            • 3. Re: Create Index by dividing by Grand Total
              Shinichiro Murakami

              Hi Trey

               

              Does this help?

               

               

              LOD

              Overview: Level of Detail Expressions

               

               

               

               

               

              FYI context filter and LOD

              Tableau's Order of Operations

               

               

              Thanks,

              Shin

              • 4. Re: Create Index by dividing by Grand Total
                Trey Weeks

                Shin,

                 

                This definitely helps. My new question: is it possible to have the index values recalculated if you were to change any of the Airline filters? For example the current view you are showing only has those 9 Airlines, therefore the index does not equal 100%, is it possible to take into account the airline filters so it always equals 100% no matter what you are comparing? Does right click "Add to context" solve what I am trying to do?

                 

                Thanks,

                Trey