1 Reply Latest reply on Nov 15, 2018 8:18 AM by Norbert Maijoor

    Creating table ranking of vendors?

    Kara Hudson

      Hi all. This is my first post and I'm a little bit of a Tableau newbie, although learning quickly. I'm hoping to find some help with a project here.

       

      I've been tasked with creating an anonymous ranking of vendors based on an existing Tableau report that I didn't build. (Fun, huh?) The existing dashboard already provides scoring by region, by vendor, something like this.

      MarketRed VendorYellow VendorBrown VendorGreen VendorBlue Vendor
      Black Vendor Purple VendorOrange VendorWhite Vendor

      North

      .7.49.55.72
      South.9.85.70.60.89.81.43.87

      East

      .75.73

      .76

      .50.59.66

      West

      .95.14.43.67.55
      Central.53.8.72.22.11

       

      What I need to be able to do is anonymize the vendor names and sort them by region in order of ranking. The tricky part here is that Vendor 1 (anonymized), won't be the same for each region. The finished table would look something like this:

       

      MarketVendorVendorVendorVendorVendor
      Vendor VendorVendorVendor

      North

      .72.7.55.49
      South.9.89.87.85.81.70.60.43

      East

      .76.75.73

      .66

      .59.50

      West

      .95.67.55.43.14
      Central.8.72.53.22.11


      I feel like I'm beating my head against a brick wall in trying to figure this out. Does anyone have any ideas or suggestions on how to approach this?

        • 1. Re: Creating table ranking of vendors?
          Norbert Maijoor

          Hi Kara,

           

          Not sure but find my "attempt" as reference below and stored in attached workbook version 2018.2 located in the original thread.

           

           

           

          index markt.jpg

           

          1. M1. Rank: RANK_UNIQUE(sum([Value]))

           

          D1. Anynomize Vendor:

          if [Vendor]='Blue Vendor' then 'Vendor1'

          elseif [Vendor]='Bron Vendor' then 'Vendor2'

          elseif [Vendor]='Black Vendor' then 'Vendor3'

          elseif [Vendor]='Orange Vendor' then 'Vendor4'

          elseif [Vendor]='Green Vendor' then 'Vendor5'

          elseif [Vendor]='Purple Vendor' then 'Vendor6'

          elseif [Vendor]='Red Vendor' then 'Vendor7'

          elseif [Vendor]='White Vendor' then 'Vendor8'

          elseif [Vendor]='Yellow Vendor' then 'Vendor9'

          END

           

          2.  Drag object to the rows shelf and change Rank to discrete and position it between Market and Anynomize Vendor

           

          3. Right click Rank > Text menu > Compute Using > D1. Anynomize Vender

           

           

           

          Hope it helps.

           

          Regards,

          Norbert