4 Replies Latest reply on Jul 17, 2018 5:44 AM by Jesper Hermenius

    Calculating the highest applicable attribute.

    Jesper Hermenius

      Hello, im fairly new to tableau and im trying to create a calculated field that would show the highest applicable tier for each product as well as one that shows the name of the highest tier.

      here is the sample data.

       

      producttier1tier2tier3tier4tier5
      prod1NANANANANA
      prod25pcs11pcs12pcsNANA
      prod312pcsNANANANA
      prod44pcs123pcs43pcs56pcs23pcs
      prod5NA3pcs15pcs30pcs54pcs

      the result im loking for would look something like this.

      ProductOnTiertier
      prod1NANA
      prod212pcstier3
      prod312pcstier1
      prod423pcstier5
      prod554pcstier5

       

      i have attached a workbook with the data.

       

      Thanks in advance